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
- 16655 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / dl
Hi Achoudhr,
here u go,
sq--->agg----->target
In agg dont use group by on any port and take output
columns for both id & date ports, use 'min' function in
outpput expression and connect output ports to desired
target columns.you will get only one output row that is 101
2/4/2008.
note: if u use group by mapping outputs 3 rows.
| Is This Answer Correct ? | 15 Yes | 6 No |
Post New Answer View All Answers
4 yrs etl devloper roles and responsibilities?any body give solutions
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain lookup transformation is active in informatica
What does role playing dimension mean?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
what is the size of u r source(like file or table)?
State the differences between sql override and lookup override?
What is target designer and target load order?
What is expression transformation?
Explain the aggregator transformation?
What are the new features of informatica 9.x at the developer level?
Explain about Informatica server process that how it works relates to mapping variables?
What are the main issues while working with flat files as source and as targets ?
What does update strategy mean, and what are the different option of it?
