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
- 13674 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
Is it possible to create multiple domains on a single Informatica server?
difference between informatica 8.1.1 and 8.6
What is the use of source qualifier?
Define joiner transformation?
What are some examples of informatica etl programs?
What are the databases that informatica can connect to windows?
How to use procedural logic inside infromatica?
difference between repository database and repository service?
What is the need of etl tools?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
explain about unit testing? in real time?
What is Cognos script editor?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How many types of sessions are there in informatica.please explain them?
What is a predefined event?
