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
- 10012 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / souvik
We need to have a Lookup with a Dynamic Cache, a Router, an Expression and then an Update Strategy..... The Lookup will be on the Target Table..... So when the ID is coming for the first time, it wont found any data on the lookup table.... This can be directed for Insertion to the Target Table via a Router.... Then when the same ID is coming for the second time, it will Lookup on the Target Table and will found that the row with the ID exists.... Hence both the columns from the source table and both the columns from the Lookup are taken forward into the Router and then to an Expression Transformation where the second port is Concatenated. Then the ID port and this port is taken to the Update Strategy transformation for Update...
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain pmcmd command usage in informatica
What is a pre-defined event and user-defined event?
How union transformation is used?
What is deployment group?
Explain your project of banking domian.
What is fact table? Explain the different kinds of facts.
What is informatica powercenter repository?
what is mean by complex business rule ?
Explain in detail scd type 2 through mapping.
What are the measure objects?
In informatics server which files are created during the session rums?
Explain scd type 3 through mapping.
What does role playing dimension mean?
What is option by which we can run all the sessions in a batch simultaneously?
