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 13575

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

SS Solutions,

1 6916

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

6 26700

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

2 12432

how CAN we remove duplicates in dataset?

IBM,

2 9607

Is it possible to query a hash file?

IBM,

1951

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 6239

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 20096

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

Tech Mahindra,

2 9665

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

Tech Mahindra,

3 10294

source contains 2 columns comes to target 4 columns how

IBM,

1 5092

how to validate the jobs

IBM,

2 7473

Main Function of the Staging area in DWH ?

2 6356

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 6320

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 4093

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

how many rows sorted in sort stage by default in server jobs

3929

How do you reject records in a transformer?

1060

Give an idea of system variables.

962

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1193

Enlist various types of routines in datastage.

1185

What is job control?

1034

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2176

Name the third party tools that can be used in datastage?

1021

What is meta stage?

1131

Explain usage analysis in datastage?

1095

how to export or import the jobs in .ISX file

1132

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1331

Can you explain how could anyone drop the index before loading the data in target in datastage?

1440

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

1205

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3698

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