suppose i have source
101 a
101 b
101 c
101 d i want target like 101 abcd how will u achive this
please give me the answer
Answer Posted / babu
Hi Aruna,
U r answer has small change,i.e one output port and in
aggregator t/r column1 is group by port not column2.
SRC
|
SQ
|
EXP
{
(variable port) var:IIF(col1=var1,concat(var,col2),col2)
(variable port) var1:(col1)
(output port) oup:var
}
|
AGGR(COL1 AS A GROUP BY PORT)
|
TRG
MAPPING DESIGN::
SRC-->SQ-->EXP-->AGGR-->TRG
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How can we remove the duplicates from flat file source?
How to create Target definition for flat files?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the fact table?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the Rank index port in Rank transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain the different lookup methods used in informatica?
How to configure mapping in informatica?
According to his methodology what all you need before you build a datawarehouse
What is a sequence generator transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?