Search code examples
informaticainformatica-powercenter

Informatica - SQ transformation

What will be the expected result of the below.

I have table A with column1, I'm trying to map column1 to SQ, which has 3 columns - col1, col2 and col3. Link Column1 to col1,col2 and col3 in SQ. Now when I try to generate SQL query for SQ, what will be the result?

Solution

  • Since OP is waiting for answer and doesnt have informatica to test it out, let me answer to that.
    if you connect one column to three columns in SQ and then connect all those three columns to next transformation, then your generated SQL will contain one column repeated thrice from source. Here are some screenshot from a dummy map i created. mapping screenshot - mapping Then here is generate SQL - Generated SQL

    SELECT 
ITEM.ITEM_NUM, ITEM.ITEM_NUM, ITEM.ITEM_NUM 
FROM
 ITEM