- 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 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 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: 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: 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: 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: What are OConv () and Iconv () functions and where are they used?

Answer: iconv is used to convert the date into into internal format i.e only datastage can understand

example :- date comming in mm/dd/yyyy format

datasatge will conver this ur date into some number like :- 740

u can use this 740 in derive in ur own format by using oconv.

suppose u want to change mm/dd/yyyy to dd/mm/yyyy

now u will use iconv and oconv.

ocnv(iconv(datecommingfromi/pstring,SOMEXYZ(seein help which is iconvformat),defineoconvformat))
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: 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 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: 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: 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:
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: 1* what is the diffrance betwin DNS DHCP ?
file system of windows?
compare with nis & dns

Answer: No answer available currently.
Question: How to find the number of rows in a sequential file?

Answer: Using Row Count system variable Source:
Question: How much would be the size of the database in DataStage ?
What is the difference between Inprocess and Interprocess ?

Answer: In-process

You can improve the performance of most DataStage jobs by turning in-process row buffering on and recompiling the job. This allows connected active stages to pass data via buffers rather than row by row.

Note: You cannot use in-process row-buffering if your job uses COMMON blocks in transform functions to pass data between stages. This is not recommended practice, and it is advisable to redesign your job to use row buffering rather than COMMON blocks.

Inter-proces Source:
Question: What is DS Designer used for - did u use it?

Answer: You use the Designer to build jobs by creating a visual design that models the flow and transformation of data from the data source through to the target warehouse. The Designer graphical interface lets you select stage icons, drop them onto the Designer work area, and add links.
Question: What is the difference between sequential file and a dataset? When to use the copy stage?

Answer: Sequentiial Stage stores small amount of the data with any extension in order to acces the file where as DataSet is used to store Huge amount of the data and it opens only with an extension (.ds ) .The Copy stage copies a single input data set to a number of output datasets. Each record of the input data set is copied to every output data set.Records can be copied without modification or you can drop or change theorder of columns. Source:
Question: What is difference between serverjobs & paraller jobs

Answer: Here is the diff

Server jobs. These are available if you have installed DataStage Server. They run on the DataStage Server, connecting to other data sources as necessary.

Parallel jobs. These are only available if you have installed Enterprise Edition. These run on DataStage servers that are SMP, MPP, or cluster systems. They can also run on a separate z/OS (USS) machine if required.

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.062012 Seconds