Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
what is the meant by Normalization and de-normalization?
what is the main role of FI on business
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What are the ETL Testing Operations?
What are the names of the layers in etl?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What is the difference between Data Warehousing and Data Mining?
Can u access a repository created in previous version of Informatica?
Explain do we need an etl tool?
What is staging area referring to?
What are your responsibilities as an etl tester?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is session partitioning?
how would u estimate the size of Aggregator transform data and index cache?
what are the concerns of OLTP and DSS systems?
