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 / ritu sharma

go the source and there is a property of skip the number of
rows.set it to 1 and then save the mapping and run the workflow.
Ritu Sharma

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do mean by local and global repository?

707


what are the deliverables?in your project?

1662


can anyone suggest best free Talend data integration training online

1263


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1136


How big was your fact table

1320






What are the designer tools for creating transformations?

686


what is $$$$?

1742


How to load data in informatica ?

581


How we can use union transformation?

612


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1842


What is session task and command task?

651


what is size of u r database?

1852


Briefly define reusable transformation?

627


Explain lookup transformation in informatica

650


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1519