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
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
When do we analyze the tables?
What is tracing level and what are the types?
What are various etl tools in the market?
What is etl process? How many steps etl contains?
can be used COM component in Informatica ?
What is grain of fact?
What is initial load and what is full load?
flat filevalidation in informatica
What is Data Vault???
how do u handle performance issues in Informatica . where can u monitor the performance ?
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
Identifying the bottlenecks in various components of Informatica and resolving them.
Identifying the bottlenecks in various components of Informatica and resolving them.
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
