Hi All,
I've 110 records in my table but 101 records contains an
error. When I run the session, I want to load the 100
records into the target. Can anyone suggest me the best
solution for this...
Thanks in Advance,
Answer Posted / srinivas
i believe this would certainly serve your purpose.
connect your source to filter transformation. if your
source contains p_key then the condition should be
p_key<=100. if it doesnt containa a primary key ex a flat
file create a new port in the filter transformation name it
s_no and connect the nextval port of seq.gen and the
condition shud be s_no<=100 and connect to the target.
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What are the uses of etl tools?
Briefly define a session task?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How will the document be delivered to me?
How can we use mapping variables in informatica?
What is olap (on-line analytical processing?
How to start a workflow using pmcmd command?
what is the hint? how to use it to reduce the query processing in program?
Suppose we do not group by on any ports of the aggregator what will be the output?
Differentiate between a database and data warehouse?
Explain the aggregator transformation?
How to load data in informatica ?
what is the complex transformation you used in informatica
how tokens will generate?
what is diff b/t sorter t/r and agg have the option sorter property...