what is a test load?

Answers were Sorted based on User's Feedback



what is a test load?..

Answer / karthik kumar

In simple words, 'test load' is a load without a 'commit' to the targets! The source qualifier fetches data and all the rows are processed through all transformations. Even the target insert queries are generated. But, rows are not inserted.
In the session log u will not find the entry of a commit issued. Also, in the session load summary, the entry will be 'Target test load summary' instead of 'Target load summary'.
The advantage of this is already evident in the above explanation. Especially when there is no access to debug mode, this option is very helpful and can be used with a verbose data to check for errors and issues.

Is This Answer Correct ?    7 Yes 0 No

what is a test load?..

Answer / reni g

With a test load, the Integration Service reads and
transforms data without writing to targets. To configure a
session to perform a test load, enable test load in session
properties and enter the number of rows to test.

Is This Answer Correct ?    1 Yes 0 No

what is a test load?..

Answer / arnab kumar patra

We can use this option to check whether the mapping will
load the data or not. We can limit the no of records that
needs to be loaded as test load in the Target properties in
the Session properties.

-Arnab

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More ETL Interview Questions

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,


What is factless fact schema?

3 Answers  


Explain about etl data integration software?

0 Answers  


Can u access a repository created in previous version of Informatica?

1 Answers  


Difference between flat files and relational sources?

0 Answers   Satyam,






how do u implement unconn.stored proc. in a mapping?

1 Answers  


how do u implement scheduling in Informatica?

1 Answers   Cognizant,


What are the different ways to deploy the code in informatica?

1 Answers   IBM, Saama Tech, Wipro,


What is a mapping?

0 Answers  


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

0 Answers  


In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  


What is staging area referring to?

0 Answers  


Categories