what is a test load?
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 |
can be used COM component in Informatica ?
what is Forward,Reverse and Re_engineering?
What are the new features of informatica 9 version?
what are the data modeling tools you have used?(polaris)
how do u identify the changed records in operational data?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
what is the use of structures?how many nodes can u create in a structure?
explain the methodology of Data Warehousing?(Polaries)
What is the difference between round-robin partitioning and hash partitioning?
Do we need an ETL tool? When do we go for the tools in the market?
what is the difference between cubes and package in cognos