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
- 8127 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 the sql query overwrite in source qualifier in informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to do the error handling of if ur source is flatfiles?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are active transformations.
How are indexes created after completing the load process?
What is expression transformation?
How to generate sequence numbers?
Where can we find the throughput option in informatica?
What are the advantages of using informatica as an etl tool over teradata?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
In warehouses how many schemas are there?
How does the aggregator transformation handle null values?
What is powercenter on grid?
