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
Answers were Sorted based on User's Feedback
Answer / ravi
can we get it by implimenting scd3 please correct me
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Answer / jz
select * from table_nme group by NO having count(*) > 1
or
Use Agg t/r group by on port 1
Is This Answer Correct ? | 0 Yes | 0 No |
What did you do in source pre load stored procedure
What are the mapping parameters and mapping variables?
How to delete duplicate records in a flat file source?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
"Change cache" in Informatica ?
have u done any performance tuning? how u ll do?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Implementation methodology
What are the basic requirements to join two sources in a source qualifier transformation using default join?
what is parameter file?
Explain sessions?
What is the difference between a shortcut of an object and copy of an object? Compare them.