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
- 19329 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 Index Caches size?
how to load dimension table and fact table. plz tell me the steps.
Explain in detail scd type 2 through mapping.
What is a surrogate key?
Performance tuning in UNIX for informatica mappings?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
State the differences between sql override and lookup override?
wf dont have integration severances how you can run?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the status code in stored procedure transformation?
Enlist the tasks for which source qualifier transformation is used.
Can we create a Integration service without a Repository service and vice versa?
How to convert multiple rows to single row (multiple columns) in informatica
Separate from a database, an information bazaar, and an information stockroom?
tell me 5 session failure in real time how can you solve that in your project?
