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 should be loaded as 1 a+b+c or 1 a||b||c, what
transformations should be used for this?
- 4 Answers
- 10322 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / babu
Sorry Shankar,
small mistake in your logic,
Exp Trans:
ID (I/O)
NAME (I)
V_NAME=IIF(ID=V_ID,V_NAME||'+'||NAME,NAME) (V)
V_ID=ID (V)
O_NAME=V_NAME (O)
=============
remaining is same.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x in developer level?
COM components can be used in Informatica
What are the components of the workflow manager?
What is domain and gateway node?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the function of aggregator transformation?
what are 3 tech challenges/ common issues you face?
How can we store previous session logs?
Is there any way to read the ms excel datas directly into informatica?
What can we do to improve the performance of informatica aggregator transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Different circumstance which drives informatica server to expel records?
Can u generate reports in Informatica?
How to Create a folder using pmrep command?
