Interested to Buy Any Domain ? << Click Here >> for more details...
what is a test load?
- 3 Answers
- 16791 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 |
What is partitioning? Explain different types of partitioning?
What is data modeling and data mining?
What is etl process. How many steps etl contains explain with example?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Eliminating of duplicate records without using dynamic lookups
What do you understand by active and passive transformations?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
how to load the data to fact table?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
Teradata 
