Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is a test load?

Answers were Sorted based on User's Feedback



what is a test load?..

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

what is a test load?..

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

what is a test load?..

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

Post New Answer

More ETL Interview Questions

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

0 Answers  


how do u extract data from different data sources explain with an example?

0 Answers  


how do use session mapping parameters ?(in which transformation)

0 Answers  


Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  


we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  


What are dimensions?

0 Answers  


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


what is the difference between cardinality and Nullability?

0 Answers  


How many steps etl contains explain with example?

0 Answers  


how to load the data to fact table?

0 Answers  


how do u automate Extraction process?

1 Answers  


Explain etl?

0 Answers  


Categories