Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

Wipro,

2 6512

What is APT_DUMP_SCORE?

IBM,

2 19263

How we can convert rows to columns in datastage?

IBM,

4 25288

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 7722

Demonstrate experience in maintaining quality process standards?

iGate,

2638

how can u find out the datastage job is running on how many nodes

IBM,

7 23334

how to capture rejected data by using join stage not for lookup stage. please let me know

Satyam,

3 20988

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 7990

What is process model?

2025

what is .dsx files

IBM,

3 12471

What are the unit test cases you used in your project?

CSC, HY,

1 10577

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

IBM,

3 7460

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 7434

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 5722

How to get max salary of an organization using data stage stages........... can any body help me plz.......

Cap Gemini,

7 30639

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Does datastage support slowly changing dimensions ?

1156

What all are the different way to run a job?

1139

What is difference between symmetric multiprocessing and massive parallel processing?

1198

How do y read Sequential file from job control?

16078

Give an idea of system variables.

1090

how to abort the job its matain duplicates?

2623

What are the various kinds of containers available in datastage?

1100

Difference between sequential file and data set?

1261

What are the processing stages?

1150

Can we use target hash file as a lookup ?

3372

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2281

in oracle target stage when we use load option and when we use upsert option?

2323

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

3810

What is the use of datastage designer?

1218

How many types of stage?

1227

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