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 / 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
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is song in infrmatica...?
Did u used latest transformations of 8.6.0? for what?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a sorter transformation?
How to create the source and target database connections in server manager?
What is deployment group?
explain about unit testing? in real time?
Briefly explain the aggregator transformation?
How do you update the records with or without using update strategy?
What can we do to improve the performance of informatica aggregator transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the reusable transformation?