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
Explain sessions?
Mention some types of transformation?
What is a node in Informatica?
How many types of sessions are there in informatica.please explain them?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
how to create user defined function (udf) in informatica
How do you promote a non-reusable transformation to reusable transformation?
Is there any target staging area in informatica not staging area
What are junk dimensions?
What do you mean by worklet?
How can we delete duplicate rows from flat files?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is DR strategy for Informatica project?
Write the prerequisite tasks to achieve the session partition?
To import the flat file definition into the designer where should the flat file be placed?