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 / azhar
Simple use sql override query:
select top1 * from TABLENAME order by ID,DATE
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
How can informatica be used for an organization?
Write the prerequisite tasks to achieve the session partition?
What is the need of etl tools?
What does update strategy mean, and what are the different option of it?
what is SDLC way of code development?
Explain the pipeline partition with real time example?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the data movement modes in informatica?
What is a connected transformation?
What is the session task and command task?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is union transformation?
Which files are created during the session rums by informatics server?