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
how to load dimension table and fact table. plz tell me the steps.
How to load last n records of file into target table - informatica
What is mapping debugger?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Define the various join types of joiner transformation?
Difference between Data and Index Caches?
In which transformation you cannot drag ports into it?
Briefly explain the aggregator transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to do the error handling of if ur source is flatfiles?
Explain load alternative records / rows into multiple targets - informatica
What is target load order?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Describe an informatica powercenter?
Define filter transformation?