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
- 13647 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 granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Slowly changing dimensions, types and where will you use them
what is informatica metadata?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Why is sorter an active transformation?
How to open an older version of an object in the workspace?
How will the document be delivered to me?
What are the different types of transformation available in informatica.
Is it possible to use a client with different version than that of its Informatica server?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the mapping parameters and mapping variables?
without table how to come first record only in oracle?
What are data-driven sessions?
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 are the different clients of powercenter?
