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
- 10146 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
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain the pipeline partition with real time example?
Whats there in global repository
How to extract the informatica rejected data?
How might one distinguish in the case of mapping is right or not without associating session?
Under what condition selecting sorted input in aggregator may fail the session?
Enlist the advantages of informatica.
Why update strategy and union transformations are active? Explain with examples.
What are the components of the workflow manager?
What are the main issues while working with flat files as source and as targets ?
What are the advantages of informatica?
how to create user defined function (udf) in informatica
Clarify the aggregator change?
what is size of u r database?
What is rank transformation in informatica
