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
how do u really know that paging to disk is happening while u are using a lookup transform?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What are the various tools used in etl?
Do we need an ETL tool? When do we go for the tools in the market?
how do u identify the changed records in operational data?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What are the ETL Testing Operations?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What is lookup table in etl testing?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Explain do we need an etl tool?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is abap? What are idocs?
how do u really know that paging to disk is happening while u are using a lookup transform?
