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
- 19328 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
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?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What do you mean by worklet?
What are Dimensional table?
What is the use of source qualifier?
Difference between Data and Index Caches?
How you know when to use a static cache and dynamic cache in lookup transformation?
What do you understand by term role-playing dimension?
Differentiate between sessions and batches?
What is joiner change?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How many ways are there to create ports?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
