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

Hi Ritu,

As per my knowledge there is no property to skip the rows
in source in case of relational table.

Please let me know if am wrong.

i would go with Answer #3 given by srinivas.

Regards,
Naveen

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

update strategy transformation in informatica

629


What is transformation?

651


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2267


Explain the scenario which compels informatica server to reject files?

648


In which transformation you cannot drag ports into it?

774






What is the difference between Active and Passive transformation?

627


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1925


How you can differentiate between connected lookup and unconnected lookup?

600


How identifying bottlenecks in various components of informatica and resolving them?

575


what are the deliverables?in your project?

1645


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6058


Could you explain what is enterprise data warehouse?

546


How do you load unique records into one target table and duplicate records into a different target table?

695


What are the popular informatica products?

642


What is informatica worklet?

601