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
explain one complex mapping with logic? sales project?
How to call shell scripts from informatica?
What is powercenter on grid?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is persistent lookup cache?
What is the way to execute pl/sql script using informatica mapping?
what is INFORMATICA TESTING process
Explain informatica architecture - version 8 / 9
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How do you remove duplicate records in informatica? And how many ways are there to do it?
if we have a delimiters at unwanted places in a flat file how can we over come those.
define galaxy repository in informatica
Explain the types of transformations?
Slowly changing dimensions, types and where will you use them
Whats there in global repository