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


Please Help Members By Posting Answers For Below Questions

Explain sessions?

603


Explain your project of banking domian.

1217


What are the advantages of using informatica as an etl tool over teradata?

564


What do you mean by enterprise data warehousing?

639


What is the difference between a repository server and a powerhouse?

803






what is the size of u r source(like file or table)?

1814


What are the tasks that can be performed using sq?

610


Quickly characterize reusable change?

687


What are the measure objects?

659


What are multi-group transformations?

562


Which are the different editions of informatica powercenter that are available?

554


How to do unit testing in informatica? How to load data in informatica ?

646


What does refresh system mean, and what are its distinctive choice?

564


What is informatica worklet?

609


What are ETL Tools?

664