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 13769

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

SS Solutions,

1 7002

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

6 26974

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

2 12563

how CAN we remove duplicates in dataset?

IBM,

2 9735

Is it possible to query a hash file?

IBM,

2006

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 6324

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 20587

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

Tech Mahindra,

2 9786

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

Tech Mahindra,

3 10462

source contains 2 columns comes to target 4 columns how

IBM,

1 5161

how to validate the jobs

IBM,

2 7601

Main Function of the Staging area in DWH ?

2 6473

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 6416

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 4221

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Define APT_CONFIG in Datastage?

1070

what is flow of project?

1997

What is the difference between datastage and informatica?

1111

What are the types of jobs we have in datastage?

1071

If you want to use a same piece of code in different jobs, how will you achieve this?

1274

What are the processing stages?

1096

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2382

Which warehouse using in your datawarehouse

2182

What are the types of views in datastage director?

1761

What are the different plug-ins stages used in your projects?

1075

how to export or import the jobs in .ISX file

1194

How do y read Sequential file from job control?

15955

Describe the main features of datastage?

1072

Define ds designer?

1274

How you can fix the truncated data error in datastage?

1783

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