Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 34454 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / jaybrata
have you guys heard of Informatica CUME() function?
Don't use seq generator, aggregator, sq override nothing.
Simply in a expression, calculate,
v_cume = CUME(1)
and after that in a filter use,
v_cume=1 OR v_cume=10
- Jaybrata
(Check www.dwbiconcepts.com)
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Explain about cumulative Sum or moving sum?
What does refresh system mean, and what are its distinctive choice?
What do you mean incremental aggregation?
Target increases every day even though no new record was inserted
What is incremental aggregation?
What is source qualifier transformation in informatica?
What is data caches/ index caches?
What is the use of target designer?
Mention few power centre client applications with their basic purpose?
Different circumstance which drives informatica server to expel records?
What is dimensional table?
What do think which one is the better joiner or look up?
Explain direct and indirect flat file loading (source file type) - informatica
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
How many dimensions are there in informatica?
