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
- 34331 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
How to start a workflow using pmcmd command?
Explain dynamic target flat file name generation in informatica
tell me the rules and responsblites in our project(my project is development)
How many number of sessions can one group in batches?
What is rank transformation in informatica
Is stop and abort are same in informatica?
If informatica has its scheduler why using third party scheduler?
How can you validate all mappings in the repository simultaneously?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Define sessions in informatica etl?
Explain how to import oracle sequence into informatica?
What are the measure objects?
What is a pre-defined event and user-defined event?
Global and Local shortcuts. Advantages.
How does the aggregator transformation handle null values?
