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
- 19569 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
What is domain and gateway node?
What are the types of caches in lookup? Explain them.
What are the components of the workflow manager?
What are session parameters ? How do you set them?
How would you copy the content of one repository to another repository?
What are the popular informatica products?
Explain about cumulative Sum or moving sum?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what is index?how it can work in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explian the Process of deployment groups in informatica
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is main use of mapplet?
What are the components of Informatica? And what is the purpose of each?
According to his methodology what all you need before you build a datawarehouse
