Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 18969 Views
- Deloitte, I also Faced
- E-Mail Answers
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
Explian the Process of deployment groups in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is the Default Source Option For Update Strategy Transformation?
How to configure mapping in informatica?
Where is metadata stored?
What are the new features of informatica 9.x developer?
What is the command used to run a batch?
What is union transformation in informatica?
While migrating the data from one environment to another environment how would you manage the connections?
What does cheating measurement mean?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
design of staging area?
Explain sessions and how many types of sessions are there?
What is the cumulative sum and moving sum?
Explain what are the different types of transformation available in informatica.
