- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
DataStage Interview Questions & Answers - Learning Mode

DataStage Interview Questions & Answers - Learning Mode

A data extraction and transformation program for Windows NT/2000 servers that is used to pull data from legacy databases, flat files and relational databases and convert them into data marts and data warehouses.

Try DataStage Interview Questions & Answers - Exam Mode

1 2 3 4 5 6 7 8 9 Next

Sort By : Latest First | Oldest First | By Rating

DataStage Interview Questions & Answers - Learning Mode
Try DataStage Interview Questions & Answers - Exam Mode
Question: How do you fix the error "OCI has fetched truncated data" in DataStage

Answer: Can we use Change capture stage to get the truncated data's.Members please confirm Source:
Question: What are the command line functions that import and export the DS jobs?

Answer: A. dsimport.exe- imports the DataStage components.
B. dsexport.exe- exports the DataStage components. Source:
Question: What is job control?how can it used explain with steps?

Answer: JCL defines Job Control Language it is ued to run more number of jobs at a time with or without using loops. steps:click on edit in the menu bar and select 'job properties' and enter the parameters asparamete prompt typeSTEP_ID STEP_ID stringSource SRC stringDSN DSN stringUsername unm stringPassword pwd stringafter editing the above steps then set JCL button and select the jobs from the listbox and run the job Source:
Question: How to run the job in command prompt in unix?

Answer: Using dsjob command,


dsjob -run -jobstatus projectname jobname

Question: What's the difference between Datastage Developers and Datastage Designers. What are the skill's required for this.

Answer: Datastage developer is one how will code the jobs.datastage designer is how will desgn the job, i mean he will deal with blue prints and he will design the jobs the stages that are required in developing the code Source:
Question: Do you know about INTEGRITY/QUALITY stage?

Answer: Integriry/quality stage is a data integration tool from ascential which is used to staderdize/integrate the data from different sources Source:
Question: What is hashing algorithm and explain breafly how it works?

Answer: Hashing is key-to-address translation. This means the value of a key is transformed into a disk address by means of an algorithm, usually a relative block and anchor point within the block. It's closely related to statistical probability as to how well the algorithms work.

It sounds fancy but these algorithms are usually quite simple and use division and remainder techniques. Any good book on database systems will have information on these techniques.

Interesting to note that t Source:
Question: How do you do Usage analysis in datastage ?

Answer: 1. If u want to know some job is a part of a sequence, then in the Manager right click the job and select Usage Analysis. It will show all the jobs dependents.

2. To find how many jobs are using a particular table.

3. To find how many jobs are usinga particular routine.

Like this, u can find all the dependents of a particular object.

Its like nested. U can move forward and backward and can see all the dependents.
Question: How can we write parallel routines in data stage PX, can anyone help out in this one quickly.
If is any example programe its very helpful to me

Answer: First you know what is routines:Routines are set of functions and its defined by DS manager and call trough help with trasformer stage. and you go to DS manager select routines left side of the window and click on routines then one pop up winndow open ther is some options like Server Routinrs, Parallal Routines and Mainframe routines u have to select which routines you want then follow it. Source:
Question: Difference between Hashfile and Sequential File?

Answer: Hash file stores the data based on hash algorithm and on a key value. A sequential file is just a file with no key column. Hash file used as a reference for look up. Sequential file cannot Source:
Question: What are the enhancements made in datastage 7.5 compare with 7.0

Answer: Many new stages were introduced compared to datastage version 7.0. In server jobs we have stored procedure stage, command stage and generate report option was there in file tab. In job sequence many stages like startloop activity, end loop activity,terminate loop activity and user variables activities were introduced. In parallel jobs surrogate key stage, stored procedure stage were introduced. For all other specifications, Source:
Question: Types of vies in Datastage Director?

Answer: There are 3 types of views in Datastage Director
a) Job View - Dates of Jobs Compiled.
b) Log View - Status of Job last run
c) Status View - Warning Messages, Event Messages, Program Generated Messages.
Question: What is APT_CONFIG in datastage

Answer: APT_CONFIG is just an environment variable used to idetify the *.apt file. Dont confuse that with *.apt file that has the node's information and Configuration of SMP/MMP server. Source:
Question: What are the different types of lookups in datastage?

Answer: There are two types of lookupslookup stage and lookupfilesetLookup:Lookup refrence to another stage or Database to get the data from it and transforms to other database.LookupFileSet:It allows you to create a lookup file set or reference one for a lookup. The stage can have a single input link or a single output link. The output link must be a reference link. The stage can be configured to execute in parallel or sequential mode when used with an input link. When creating Lookup file sets, one fi Source:
Question: How will you call external function or subroutine from datastage?

Answer: There is datastage option to call external programs . execSH Source:
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:
Question: How do you merge two files in DS?

Answer: Either used Copy command as a Before-job subroutine if the metadata of the 2 files are same or created a job to concatenate the 2 files into one if the metadata is different. Source:
Question: How can we implement Lookup in DataStage Server jobs?

Answer: The DB2 stage can be used for lookups.

In the Enterprise Edition, the Lookup stage can be used for doing lookups.
Question: What is the difference between datastage and informatica

Answer: The main difference is Vendors. Each one is having plus from their architecture. For Datastage it is a Top-Down approach. Based on the Businees needs we have to choose products. Source:
Question: How do you pass filename as the parameter for a job?

Answer: 1. Go to DataStage Administrator->Projects->Properties->Environment->UserDefined. Here you can see a grid, where you can enter your parameter name and the corresponding the path of the file.

2. Go to the stage Tab of the job, select the NLS tab, click on the "Use Job Parameter" and select the parameter name which you have given in the above. The selected parameter name appears in the text box beside the "Use Job Parameter" button. Copy the parameter name from the text box and Source:

1 2 3 4 5 6 7 8 9 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.078125 Seconds