I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
Answer Posted / lakshmi
If no errors, check if you have set "test rows" to 50 in session property.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is aggregate cache in aggregator transformation?
Define joiner transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Implementation methodology
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is informatica? Why do we need it?
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
What is a surrogate key?
difference between informatica 8.1.1 and 8.6
How do you load only null records into target?
What is substr in informatica?
What do you understand by term role-playing dimension?
How can you generate reports in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.