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 5425

What is APT_DUMP_SCORE?

IBM,

2 17953

How we can convert rows to columns in datastage?

IBM,

4 23154

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 6515

Demonstrate experience in maintaining quality process standards?

iGate,

1925

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

IBM,

7 20296

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

Satyam,

3 19237

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 6582

What is process model?

 1551

what is .dsx files

IBM,

3 11021

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

CSC, HY,

1 9535

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 6252

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 6047

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 4673

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

Cap Gemini,

7 27828

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Can you explain repository tables in datastage?

899

How to clean the datastage repository?

691

Difference between in process and inter process?

695

Why do we use exception activity in Datastage?

710

What are stage variables?

636




How do you remove duplicate values in datastage?

622

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

3376

Describe the architecture of datastage?

568

What are the components of ascential data stage?

647

How do you start developing a datastage project?

660

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

596

Difference between ‘validated ok’ and ‘compiled’ in data stage?

665

what is the difference between == and eq in UNIX shell scripting?

972

What is the difference between server job and parallel jobs?

662

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

347

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