How to create a mapping ?
id date
101 2/4/2008
101 4/4/2008
102 6/4/2008
102 4/4/2008
103 4/4/2008
104 8/4/2008
O/P - shud have only one id with the min(date)
How to create a mapping for this
Answer Posted / parthiban
S->SQ->SRT->EXP->FIL->TGT
Sort on date Column
In Expression, Create variable ports for partition
V_Currdate = date
V_Flag = IIF(V_Currdate = V_Prevdate, V_Flag+1,1)
V_Prevdate =date
O_Flag = V_Flag
In Filter, Filter where O_Flag =1
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How many ways are there to do 'remove duplicate records in informatica'?
Explain how to import oracle sequence into informatica?
How to call shell scripts from informatica?
What is primary and backup node?
Define pmcmd command?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to go to the older version for a mapping?
Where can we find the throughput option in informatica?
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
explain about unit testing? in real time?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to create Target definition for flat files?
How to elaborate tracing level?
What is the difference between Active and Passive transformation?
How will the document be delivered to me?