If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?

Answer Posted / somnath pain

In source qualifier use this query
select name from table_name group by id
now apply an aggregator transformation to concate the name
according to the group id.

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by active and passive transformation?

826


Define filter transformation?

886


Why update strategy and union transformations are active? Explain with examples.

995


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

897


What is a filter transformation and why it is an active one?

782


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7956


Explain your project of banking domian.

1425


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1408


What does role playing dimension mean?

831


What are the tuning techniques you applied during your last project

1799


What do mean by local and global repository?

955


What are the types of presistent cache in look up tr.

1841


What are the new features of informatica 9.x at the developer level?

845


What is pmcmd command?

908


What is the meaning of up gradation of repository?

1631