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
- 19571 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 is depict expression change?
Where do we use mapping variables in informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the tuning techniques you applied during your last project
When do you use sql override in a lookup transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
In warehouses how many schemas are there?
What are the issues you have faced in your project? How did you overcome those issues?
To import the flat file definition into the designer where should the flat file be placed?
How to go to the older version for a mapping?
Whats there in global repository
Differentiate between source qualifier and filter transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
r u done any partitions in ur project?
