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
have u done any performance tuning? how u ll do?
How do you handle two sessions in Informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Tell me about Propagate functions in informatica
What is the use of an aggregator cache file?
how we can load rejected record's at run time?(not through bad files)
How might one distinguish in the case of mapping is right or not without associating session?
How is union transformation utilized?
What is Session and Batches?
What all are steps in up gradation of Informatica server?
Explain sessions. Explain how batches are used to combine executions?
What can we do to improve the performance of informatica aggregator transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How to update a particular record in target with out running whole workflow?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps