Flat file heaving 1 lack records and I want to push 52000
records to the target?
Answer Posted / praveen kumar pendekanti
do the mapping as follows
source->source Qualifier->Expression->what ever u want and
final load to target.
Take sequence Generator....In Expression take one port as
Flag and connect the nextval to that port(Nextval port in
sequence generator) start nextval from one and use filter
transformation and use how many records u want.... and then
connect to Target........
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of informatica?
How can you define user defied event?
Which transformation is needed while using the Cobol sources as source definitions?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the difference between router and filter?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is dimensional table?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Explain lookup transformation in informatica
How to extract the informatica rejected data?
How union transformation is used?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Why update strategy and union transformations are active?
Define sessions in informatica etl?
What are the guidelines to be followed while using union transformation?