Interested to Buy Any Domain ? << Click Here >> for more details...
what is a test load?
- 3 Answers
- 16659 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Compare ETL & Manual development?
what are the facilities provided by OLAP to analytical users?
What is fact? What are the types of facts?
what is dynamic insert?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
what is Forward,Reverse and Re_engineering?
how do u decide whether u need to do aggregations at database level or at Informatica level?
How to Check the source record count from traget table.
What is lookup table in etl testing?
What are various etl tools in the market?
Teradata 
