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 13774

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

SS Solutions,

1 7007

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

6 27004

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

2 12577

how CAN we remove duplicates in dataset?

IBM,

2 9746

Is it possible to query a hash file?

IBM,

2012

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 6325

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 20622

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

Tech Mahindra,

2 9798

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

Tech Mahindra,

3 10471

source contains 2 columns comes to target 4 columns how

IBM,

1 5171

how to validate the jobs

IBM,

2 7609

Main Function of the Staging area in DWH ?

2 6485

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 6426

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 4232

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Lookup constraints

1256

Have you have ever worked in unix environment and why it is useful in datastage?

1133

Can you filter data in hashed file?

3772

How to reverse the string using unix?

3509

Describe the architecture of datastage?

1010

What is the difference between passive stage and active stage?

1538

Explain ibm infosphere information server and highlight its main features?

1091

How do you generate sequence number in datastage?

1094

What is the use of datastage designer?

1154

What are the benefits of datastage?

1238

What could be a data source system?

1008

Differentiate between datastage and informatica?

1181

Is possible to create skid in dim,fact tables?

2636

What is the process of killing a job in datastage?

1020

Can you implement SCD2 using join, transformer and funnel stage?

1557

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