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
Answer Posted / mitesh gaur
I think there is no need of using any aggregation. It's very
straight fwd, just sort the data on date and fetch only
first record.
Add the below query to source qualifier's SQL OVERRIDE
and that will be your result - (lets say table name is TmpTab)
select * from (select * from TmpTab order by date) where
rownum = 1;
now connect id, date to target.
Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
What are the designer tools for creating transformations?
can anyone suggest best free Talend data integration training online
Parameter and variable differences
Explain direct and indirect flat file loading (source file type) - informatica
What are different types of transformations available in informatica?
What is aggregator transformation in informatica?
How to elaborate tracing level?
Why is sorter an active transformation?
Describe expression transformation?
Can we get 1st record through Informatica(without sequence number).
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Scheduling properties,whats the default (sequential)
How many transformations can be used in mapplets.
What are the different versions of informatica?
What are the different ways to implement parallel processing in informatica?