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
- 19316 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
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are active transformations.
How do you update the records with or without using update strategy?
server hot-ws270 is connect to Repository B. What does it mean?
How many numbers of sessions can one group in batches?
What is a node in Informatica?
Write the different tools in the workflow manager?
have u done any performance tuning? how u ll do?
What the difference is between a database, a data warehouse and a data mart?
How to partition the Session?
What is lookup transformation?
How can we use mapping variables in informatica? Where do we use them?
Which files are created during the session rums by informatics server?
What is the need of an ETL tool?
Explain in detail about scd type 1 through mapping.
