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
- 19326 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / deepak
SQ --> Sorter (sort on date desc) --> Aggregator (select no ports so it will always return last row) --> Target
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between mapping parameter and mapping variable?
What do you mean by enterprise data warehousing?
What is union transformation?
What are the types of data warehouses?
Difference between Data and Index Caches?
what is the complex transformation you used in informatica
What is sorter transformation?
Partition, what happens if the specified key range is shorter and longer
Informatica settings are available in which file?
How to update or delete the rows in a target, which do not have key fields?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
In how many ways we can create ports?
How to update source definition?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
