Why do you use SQL LOADER or OCI STAGE? - When the source data is anormous or for bulk data we can use OCI and SQL loader depending upon the source - DataStage Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

DATASTAGE

DETAILS

Question: Why do you use SQL LOADER or OCI STAGE?

Answer: When the source data is anormous or for bulk data we can use OCI and SQL loader depending upon the source

Category	DataStage Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9665 users
Added on	7/26/2011
Views	71919
Rate it!

Question: Why do you use SQL LOADER or OCI STAGE?

Answer:

When the source data is anormous or for bulk data we can use OCI and SQL loader depending upon the source Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What r XML files and how do you read data from XML files and what stage to be used?	View Answer
	How many jobs have you created in your last project?	View Answer
	Tell me the environment in your last projects	View Answer
	Did you Parameterize the job or hard-coded the values in the jobs?	View Answer
	What is Hash file stage and what is it used for?	View Answer
	What are Static Hash files and Dynamic Hash files?	View Answer
	What other ETL's you have worked with?	View Answer
	Did you work in UNIX environment?	View Answer
	How good are you with your PL/SQL?	View Answer
	Explain the differences between Oracle8i/9i?	View Answer
	Do you know about INTEGRITY/QUALITY stage?	View Answer
	Do u know about METASTAGE?	View Answer
	What are OConv () and Iconv () functions and where are they used?	View Answer
	What are Routines and where/how are they written and have you written any routines before?	View Answer
	What are other Performance tunings you have done in your last project to increase the performance of slowly running jobs?	View Answer
	What are Sequencers?	View Answer
	What will you in a situation where somebody wants to send you a file and use that file as an input or reference and then run job.	View Answer
	What is the utility you use to schedule the jobs on a UNIX server other than using Ascential Director?	View Answer
	What are the command line functions that import and export the DS jobs?	View Answer
	Difference between Hashfile and Sequential File?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DataStage Interview Questions & Answers - Exam Mode / Learning Mode