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
- 16675 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
whats the logic to load the lower level of granularity of data to fact table.
How to create Target definition for flat files?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the tasks that source qualifier perform?
How to generate sequence numbers using expression transformation?
What is the surrogate key?
What is a node in Informatica?
What is rank transformation?
Explain transaction control transformation in informatica
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is workflow? What are the components of the workflow manager?
What is the need for an etl tool?
How to join three sources using joiner?
Explain the tuning lookup transformation - informatica
Which version configuration tool used in ur project?
