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 / pavana
You can use sequence generator and then in exp trn, use a
variable which reads the 1st number the seq generates and
use filter transformation and take only 1st generated row
and +10th record.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
How can you increase the performance in joiner transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Where are the source flat files kept before running the session?
Explain target update override in informatica
Can we create a Integration service without a Repository service and vice versa?
What is a surrogate key?
Which is the t/r that builts only single cache memory?
Explain lookup transformation in informatica
Explain in detail about scd type 1 through mapping.
What is a snowflake schema?
Mention few advantages of router transformation over filter transformation.
What is the need of etl tools?
Repository user profiles
What are the modules in Power Center