Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
In source I have records like this
No name address
10 manoj mum
10 manoj dilhi
20 kumar usa
20 kumar Tokyo
I want records in target like shown below
No name addr1 addr2
10 manoj mum dilhi
20 kumar usa Tokyo
If it is reverse we can do this by using Normalizer
transformation by setting occurance as 2.
Somebody will say use denoralization technique. But as of my
knowledge I couldn’t find any denormalization technique. Is
there any concept like that?
I tryid this seriously but I could find any idea to
implement this.
Can any one please help me ?
Advance Thanks
- 6 Answers
- 8297 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / satish
Use a dynamic lookup to check if the record exists,
If it is not then
Insert that record in No , Name and Address1
If it is then use that record to update the address 2 field always, this might be a case where the client wants to keep the first record and current record in the address 2 field
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
expain about the tune parameters?
What is union transformation?
Enlist the various types of transformations.
Enlist some properties of sessions.
In informatics server which files are created during the session rums?
What are the guidelines to be followed while using union transformation?
What is aggregator transformation in informatica?
What is different between the data warehouse and data mart?
What all are steps in up gradation of Informatica server?
What are the differences between a connected lookup and unconnected lookup?
Define mapplet?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain what are the different types of transformation available in informatica.
draw informatica architecture 8.6 ?
What is event and what are the tasks related to it?
