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
- 18968 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
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What do you mean by worklet?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Differences between connected and unconnected lookup?
Enlist the advantages of informatica.
how we can load rejected record's at run time?(not through bad files)
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Do you find any difficulty while working with flat files as source and target?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to generate sequence numbers?
What are the different components of powercenter?
What is a pre-defined event and user-defined event?
How you can differentiate between connected lookup and unconnected lookup?
What are multi-group transformations?
What is repository manager?
