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 / sri

thank you for the answer, but I'm just wondering where to
write this code.
Could you let me know about the same.


Thanks,

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are active transformations.

1190


What is union transformation in informatica?

701


What is option by which we can run all the sessions in a batch simultaneously?

667


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

630


what are the Methods For Creating Reusable Transformations?

649






IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

564


Clarify the utilization of aggregator cache record?

578


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7681


What is the surrogate key?

644


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3515


What is decode in static cache?

596


What is a surrogate key?

563


How do you remove duplicate records in informatica? And how many ways are there to do it?

715


Explain constraint based loading in informatica

661


What do you mean by blocking transformation?

585