Interested to Buy Any Domain ? << Click Here >> for more details...
what is a test load?
- 3 Answers
- 16773 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 |
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
where are the log files generally stored.Can you change the path of the file.what can the path be?
Difference between flat files and relational sources?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what are variable ports and list two situations when they can be used?
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
What is the difference between project backlog and product backlog?
Eliminating of duplicate records without using dynamic lookups
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Explain the use lookup tables and Aggregate tables?
Explain me ETL project architecture in Detail?
How many steps etl contains explain with example?
Teradata 
