Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - I have to extract data from a flat file. The flat file has 10 records. I have to extract the 1st and 5th record every time. How is it done?




515
views
asked marvit September 20, 2014 08:01 AM  

I have to extract data from a flat file. The flat file has 10 records. I have to extract the 1st and 5th record every time. How is it done?


           

1 Answers



 
answered By vishnoiprem   0  
We can do it through below flow

SQ->EXP TRANSFORMER->FILTER->Target
|
SG

Where as SQ =source Qualifier

EXP TRANSFORMER=Expression transformer

SQ= Sequence Generator use to generate sequence number

In this e.g. we will use sequence generator to generate sequence
1 to 5 and incremental by 1 in sequence with max value 5

in filter we will use condition seq_nr=5
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert