Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

What is the default execution order of the sequential file?

3 13948

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

SS Solutions,

1 7078

How many input links can you give to a Transformer stage?

6 27199

Can aggregator and transformer stages use to sort the data? How ?

2 12692

how CAN we remove duplicates in dataset?

IBM,

2 9871

Is it possible to query a hash file?

IBM,

2059

How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

IBM,

1 6389

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

Bank Of America, IBM,

13 20983

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

Tech Mahindra,

2 9890

how many dimentions and fact tables used in your project and what are names of it?

Tech Mahindra,

3 10595

source contains 2 columns comes to target 4 columns how

IBM,

1 5237

how to validate the jobs

IBM,

2 7698

Main Function of the Staging area in DWH ?

2 6564

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

TCS,

1 6506

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

TCS,

1 4321

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

what are the errors,warnings in datastage

2764

How do you remove duplicate values in datastage?

1196

What are orabulk and bcp stages?

1164

what is repositery?

1927

What are the some differences between 7.x and 8.x version of datastage?

1305

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2324

What are the main differences you have observed between 7.x and 8.x version of datastage?

1133

What is the difference between account and directory options ?

1233

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1600

Difference between sequential file and data set?

1260

How to read the length of word in unix?

1433

What are the various kinds of containers available in datastage?

1100

What are the different options associated with dsjob command?

1483

How do you run datastage job from the command line?

1129

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1795

For More Un-Answered { Data Stage } Questions Click Here