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
- 12997 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
What is joiner change?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
To import the flat file definition into the designer where should the flat file be placed?
What is the session task and command task?
What is the difference between STOP and ABORT options in Workflow Monitor?
can u give example for factless fact table
How to generate sequence numbers?
Describe an informatica powercenter?
What are the different clients of powercenter?
How to join three sources using joiner? Explain though mapping flow.
wat are deployement groups in informatica, how it will be used for developers
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is exclusive and normal mode for repository services?
How do you take back up of repository?
