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
- 19302 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
In warehouses how many schemas are there?
What is the advantage of informatica?
Explain Dataware house architecture .how data flow from intial to end?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How can we create index after completion of load process?
What are mapplets? How is it different from a Reusable Transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a code page?
What is resilience time?
Tell me about Propagate functions in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to extract sap data using informatica?
What is joiner change?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
