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
- 19574 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / rob
Add the below query to source qualifier's SQL OVERRIDE
and you will get the required output
select * from (select min(to_date(date,'dd/mm/yyyy'))as
d,id from emp
group by id order by d)where rownum =1;
source-->SQualifier(with query)----> target
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
What is the benefit of partitioning a session?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is workflow manager?
What are the static cache and dynamic cache in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to open an older version of an object in the workspace?
How do you load alternate records into different tables through mapping flow?
Which development components of informatica have the highest usage?
What is dimensional table? Explain the different dimensions.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
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 are the best practices to extract data from flat file source which are bigger than 100 mb memory?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
