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
- 10316 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
difference between repository database and repository service?
How can you define user defied event?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
expain about the tune parameters?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the differences between a connected lookup and unconnected lookup?
What is an Integration service in Informatica?
What are the types of schemas we have in data warehouse.
Explain about Informatica server process that how it works relates to mapping variables?
How do you migrate data from one environment to another?
How can we update a record in the target table without using update strategy?
What are the differences between oltp and olap?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the transformations that are not supported in mapplet?
What is an expression transformation?
