Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 13800 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the different lookup cache(s)?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to join three sources using joiner?
What is complex mapping?
Explain lookup transformation in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to generate sequence numbers using expression transformation?
What is a pre-defined event and user-defined event?
How many transformations can be used in mapplets.
Why update strategy and union transformations are active? Explain with examples.
What does reusable transformation mean?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to elaborate tracing level?
What is intricate mapping?
