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
- 8045 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
What is informatica powercenter repository?
How do you update the records with or without using update strategy?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the restrictions of union transformation?
What are the different components of powercenter?
How does the aggregator transformation handle null values?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is union transformation in informatica?
How to start a workflow using pmcmd command?
What is an unconnected transformation?
What are the advantages of using informatica as an etl tool over teradata?
What is the difference between router and filter?
Under what condition selecting sorted input in aggregator may fail the session?
Explain dynamic target flat file name generation in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
