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
expain about the tune parameters?
According to his methodology what all you need before you build a datawarehouse
Explain what are the different versions of informatica?
Enlist the tasks for which source qualifier transformation is used.
How to load a Dimension ? and how to load a fact table?
How do you take back up of repository?
In development project what is the process to follow for an etl developer from day1
How to create a non-reusable instance of reusable transformations?
What is complex mapping?
What are the different options available for update strategy?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by query override?
Explain the tuning lookup transformation - informatica
What are active and passive transformations?