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
- 34076 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
What is the use of an aggregator cache file?
What are the new features of informatica 9.x at the developer level?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Define enterprise data warehousing?
How to start a workflow using pmcmd command?
What do you mean incremental aggregation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What do you mean by enterprise data warehousing?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What differs when we choose the sorted input for aggregator transformation?
Which transformation should we use to normalise the COBOL and relational sources?
How can you generate reports in informatica?
What could be the possible resons of locks by user?
Write the advantages of partitioning a session?
what is song in infrmatica...?
