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?
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 all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are mapplets?
Mention a few design and development best practices for informatica?
How to go to the older version for a mapping?
can we override a native sql query within informatica? How do we do it?
what is size of u r database?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
whats the logic to load the lower level of granularity of data to fact table.
What's the layout of parameter file (what does a parameter file contain?)?
What is the reusable transformation?
What are the mapping parameters and mapping variables?
What are mapplets? How is it different from a Reusable Transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Write the program through which the records can be updated?
update strategy transformation in informatica