Data Stage Interview Questions
Questions Answers Views Company eMail

What is the default execution order of the sequential file?

3 12084

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

SS Solutions,

1 5982

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

6 24583

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

2 11505

how CAN we remove duplicates in dataset?

IBM,

2 8705

Is it possible to query a hash file?

IBM,

1552

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 5535

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 16807

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

Tech Mahindra,

2 8637

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

Tech Mahindra,

3 8952

source contains 2 columns comes to target 4 columns how

IBM,

1 4430

how to validate the jobs

IBM,

2 6615

Main Function of the Staging area in DWH ?

2 5400

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 5673

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 3183


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are stage variables and constants?

690


What are constraints and derivations?

637


What are orabulk and bcp stages?

636


What are system variables and sequencers in datastage

595


What is the purpose of pivot stage?

594






How do you schedule or monitoring the job?

650


how to implement scd2 in datastage 7.5 with lookup stage

5113


How many types of sorting methods are available in datastage?

616


What are the types of containers in datastage?

690


How to read the length of word in unix?

870


What are the types of jobs we have in datastage?

658


What are sequencers?

604


How can you write parallel routines in datastage PX?

609


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1731


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

723