If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?
Answer Posted / saritha
you can use normalizer or expersion transformation.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
What are some examples of informatica etl programs?
What is a repository manager?
How to elaborate powercenter integration service?
What are active and passive transformations?
what is the hint? how to use it to reduce the query processing in program?
What do you mean by blocking transformation?
whats the logic to load the lower level of granularity of data to fact table.
What are the different clients of powercenter?
What is update strategy transform?
What is union transformation in informatica?
What is enterprise data warehousing?
What is rank transform?
Explain what are the different versions of informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?