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

Explain dynamic target flat file name generation in informatica

652


update strategy transformation in informatica

644


waht type of interface is used for testing the data in informatica

1835


How do you load first and last records into target table?

669


What is dimensional table? Explain the different dimensions.

665






How can we improve session performance in aggregator transformation?

677


Briefly explain the aggregator transformation?

604


What is a joiner transformation and why it is an active one?

580


How do you convert single row from source into three rows into target?

607


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1503


What is decode in static cache?

596


Different sorts of metadata that stores in the storage facility?

563


Difference between Data and Index Caches?

661


What is the way to execute pl/sql script using informatica mapping?

966


How big was your fact table

1320