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
How to create or import flat file definition in to the warehouse designer?
What can we do to improve the performance of informatica aggregator transformation?
What is target load order?
what is the size of your data warehousing?
What are the tuning techniques you applied during your last project
What is a joiner transformation?
In informatics server which files are created during the session rums?
How can you generate reports in informatica?
How to update or delete the rows in a target, which do not have key fields?
Design time, run time. If you don't create parameter what will happen
How do you promote a non-reusable transformation to reusable transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the differences between joiner transformation and source qualifier transformation?
what is diff b/t sorter t/r and agg have the option sorter property...