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
tell me about your project functionality
What do you understand by term role-playing dimension?
What is the session task and command task?
What are the designer tools for creating transformations?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to update or delete the rows in a target, which do not have key fields?
What is DR strategy for Informatica project?
wat are deployement groups in informatica, how it will be used for developers
what is the complex transformation you used in informatica
What is a filter transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
how many types of dimensions are available in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?