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
What is meant by active and passive transformation?
Define filter transformation?
Why update strategy and union transformations are active? Explain with examples.
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?
What is a filter transformation and why it is an active one?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain your project of banking domian.
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.
What does role playing dimension mean?
What are the tuning techniques you applied during your last project
What do mean by local and global repository?
What are the types of presistent cache in look up tr.
What are the new features of informatica 9.x at the developer level?
What is pmcmd command?
What is the meaning of up gradation of repository?