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
- 9969 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
Explain dynamic target flat file name generation in informatica
What is informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
tell me 5 session failure in real time how can you solve that in your project?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is target designer and target load order?
what is Active lock explain
Explain in detail scd type 2 through mapping.
What are the limitations of joiner transformation?
Is there any target staging area in informatica not staging area
what is informatica metadata?
4 yrs etl devloper roles and responsibilities?any body give solutions
What are batches?
What is the format of informatica objects in a repository?
As union transformation gives UNION ALL output, how you will get the UNION output?
