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 6419

What is APT_DUMP_SCORE?

IBM,

2 19123

How we can convert rows to columns in datastage?

IBM,

4 25092

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 7591

Demonstrate experience in maintaining quality process standards?

iGate,

2552

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

IBM,

7 23076

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

Satyam,

3 20862

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 7857

What is process model?

1976

what is .dsx files

IBM,

3 12336

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

CSC, HY,

1 10459

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 7341

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 7267

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 5626

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

Cap Gemini,

7 30424

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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

1156

What is ds designer?

1104

Define Data Stage?

1092

What are sequencers?

1115

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

How to RD using transformer?

1424

Explain usage analysis in datastage?

1163

What is the difference between hashfile and sequential file?

1260

How many types of hash files are there?

1185

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460

why do u need the IOS upgradation in a FC switch

2282

Differentiate between data file and descriptor file?

1059

What a datastage macro?

1060

Have you used Unstructured data?

1320

How can you write parallel routines in datastage PX?

1015

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