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
- 10185 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 differences between a connected lookup and unconnected lookup?
What do you mean by channel change?
What is the use of code page?
How do you update the records with or without using update strategy?
What are the different ways to implement parallel processing in informatica?
explain abt ur project architecture?
What do you understand by a term domain?
Describe an informatica powercenter?
What is workflow monitor?
How to go to the older version for a mapping?
Explain the features of connected and unconnected lookup.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How can you generate reports in informatica?
What is lookup change?
What are the designer tools for creating transformations?
