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 27000

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

2 12576

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 20616

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

Tech Mahindra,

2 9796

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

Tech Mahindra,

3 10470

source contains 2 columns comes to target 4 columns how

IBM,

1 5171

how to validate the jobs

IBM,

2 7608

Main Function of the Staging area in DWH ?

2 6484

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 6423

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 }

State the difference between an operational datastage and a data warehouse?

1131

What is the difference between an operational datastage and a data warehouse?

1154

Why do you need stage variables?

1180

Give an idea of system variables.

1032

What is the use of datastage designer?

1154

Whats difference betweeen operational data stage (ods) and data warehouse?

1114

Which commands are used to import and export the datastage jobs?

1413

Define oconv () and iconv () functions in datastage?

1416

How you Implemented SCD Type 1 & Type 2 in your project?

4129

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

Define repository tables in datastage?

1157

Differentiate between data file and descriptor file?

1056

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3165

Describe the architecture of datastage?

1008

What is data partitioning?

1202

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