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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to update source definition?
What is the Process to creating lookup transformation in informatica
lookup transformation with screenshots
Explain about Informatica server process that how it works relates to mapping variables?
What are the advantages of informatica?
How many ways are there to do 'remove duplicate records in informatica'?
How can you generate reports in informatica?
Explain how to import oracle sequence into informatica?
Write the unconnected lookup syntax?
What is Index Caches size?
What is the difference between informatics 7x and 8x and what is latest version?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the components of Informatica? And what is the purpose of each?
What are the modules in Power Center