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 |
When do we analyze the tables?
What is grain of fact?
What are the key benefits of ETL Testing?
Is hadoop a etl tool?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
Mention few test cases and explain them?
What is data modeling and data mining?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
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?
what is the difference steps for data modeling?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com