Simple use sql override query: select top1 * from TABLENAME order by ID,

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

Question Posted / azhar

9 Answers
18993 Views
Deloitte, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What the difference is between a database, a data warehouse and a data mart?

1082

What are active and passive transformations?

1023

How to differentiate between the active and passive transformations?

1078

Please let me know how to make encryption and decryption with example?

1848

What are the different clients of powercenter?

1006

What do think which one is the better joiner or look up?

1143

What is the difference between router and filter?

1156

Explain joiner transformation in informatica

1077

What are junk dimensions?

1022

Which transformation should we use to normalise the COBOL and relational sources?

1143

Write the prerequisite tasks to achieve the session partition?

1075

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1138

How to load data in informatica ?

956

Define mapplet?

964

What is target load order?

1190