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

Informatica - Flat file heaving 1 lack records and I want to push 52000 records to the target?




998
views
asked marvit September 20, 2014 08:03 AM  

Flat file heaving 1 lack records and I want to push 52000 records to the target?


           

1 Answers



 
answered By vishnoiprem   0  
if the source is flat file we don't generate any SQL query in     the source qualifier.
then we are using the following way,
seqgen
|
sd-->sq-->expr-->filter--> td.
in the filter condition expression we take nextval<=52000.


you have 100000 records and you want to load 52k records in
the target. then,
source definition--> source qualifier-->target definition.
open source qualifier properties select SQL query,in that
field generate the query with WHERE clause rownum<=52000. and
run the session.
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