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 A Datastage?

2 4931

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

Hexaware,

1 6642

What is Horizontal transformation, vertical transformation,diagonal transformation?

Cap Gemini,

2 9855

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

TCS,

1 4295

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

TCS,

3 10042

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

IBM,

3 9252

How can remove duplicates in a file using UNIX?

Cap Gemini,

3 12245

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

TCS,

1 6619

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

Hexaware,

1 6337

how to configure databases through datastage

2 12344

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 9666

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 11259

how to retrive the max(sal),deptno,empno in datastage?

Polaris,

13 24486

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

Polaris,

10 17169

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

Accenture,

3 23735

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Triggers,VIEW,Procedures

1220

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

What is the different type of jobs in datastage?

974

What is the difference between Datastage 7.5 and 7.0?

1096

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3794

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

CHANGE CAPTURE

1300

Which warehouse using in your datawarehouse

2185

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

root tree will find which is server job and which is parallel job?

1967

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4044

How to convert RGB Value to Hexadecimal values in datastage?

3996

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

779

How can one find bugs in job sequence?

1411

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