in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
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 a sorter transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
How do you change a non-reusable transformation to reusable transformation?
How do you load alternate records into different tables through mapping flow?
What is InformaticaPowerCenter?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Why do you use Mapping Parameter and mapping variable?
Define update strategy?
Under which circumstances, informatica server creates reject files?
What is a stored procedure transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is informatica powercenter repository?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are junk dimensions?
How can we handle two sessions in informatica?