1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
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 5409

What is APT_DUMP_SCORE?

IBM,

2 17933

How we can convert rows to columns in datastage?

IBM,

4 23125

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 6493

Demonstrate experience in maintaining quality process standards?

iGate,

1913

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

IBM,

7 20263

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

Satyam,

3 19216

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 6557

What is process model?

 1539

what is .dsx files

IBM,

3 10983

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

CSC, HY,

1 9517

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 6220

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 6021

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 4663

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

Cap Gemini,

7 27771

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are orabulk and bcp stages?

636

What is the difference between server job and parallel jobs?

656

what is the custome stage in datastage? how can we impliment that one? plz tell me

1899

Enlist various types of routines in datastage.

634

How to read multiple files using a single datastage job if files have the same metadata?

722




how can we create rank using datastage?what is the meaning of rank?

8150

What are the types of hashed files in data stage

632

Can you highlight the main features of ibm infosphere information server?

628

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

2261

why do u need the IOS upgradation in a FC switch

1860

How complex jobs are implemented in datstage to improve performance?

584

Can you explain kafka connector?

763

What is the purpose of pivot stage and types of containers in datastage

602

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1113

What is the difference between informatica and datastage?

646

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