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 / rajesh.a
We need to use sorter,Expression and aggregator transformations to do this
1.Sort by ID
2.Take 2 variable ports one for id and one for name and store the values of id and keep on comparing with current id i.e variable is having previous id.
so,if previous id=current id then (variable name)||name otherwise only name.assign the variable name to output port
3.Use aggregator and use last or max(len(name)) to get the result
Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
How do you take back up of repository?
Briefly define reusable transformation?
How to update or delete the rows in a target, which do not have key fields?
Define filter transformation?
Design time, run time. If you don't create parameter what will happen
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are Dimensional table?
How do you load only null records into target?
What does role playing dimension mean?
How can we handle two sessions in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Describe data concatenation?
What are mapplets? How is it different from a Reusable Transformation?
Which transformation is needed while using the Cobol sources as source definitions?
What is a sequence generator transformation?