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
- 19301 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
How many dimensions are there in informatica?
Different sorts of metadata that stores in the storage facility?
can anyone explain me about retail domain project in informatica?
According to his methodology what all you need before you build a datawarehouse
What are the various types of transformation?
What are junk dimensions?
Describe data concatenation?
Why union transformation is an active transformation?
What is the use of source qualifier?
How to create or import flat file definition in to the warehouse designer?
How do you load only null records into target? Explain through mapping flow.
How to extract sap data using informatica? What is abap? What are idocs?
What is data movement mode in Informatica and difference between them?
Which version configuration tool used in ur project?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
