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

Data Stage Interview Questions

Questions Answers Views Company eMail

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

TCS,

2 5244

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

IBM,

1 4210

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

IBM, YCS,

3 6625

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

Wipro,

4 8085

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 6208

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

IBM,

3 7531

What is the difference between Link collector and Funnel Stages?

1 7112

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

HCL,

1 4492

count number of deptno in a emp table?

IBM,

2 5310

deptno wise to find max and min,and sum of rows and in target to company wise maximum

IBM, TCS,

1 4714

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

Deloitte, IBM,

3 10045

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

HSBC,

2 6277

what is flow of project?

HSBC, IBM,

1938

explain about citrix scheduling tool in datastage

HSBC,

2382

how to run jon in unix back round process what is command use in runing a job?

HSBC,

2 6215

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the types of containers in datastage?

1143

How you can fix the truncated data error in datastage?

1677

how to export or import the jobs in .ISX file

1133

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

3736

What is the difference between orabulk and bcp stages?

969

What are the different layers in the information server architecture?

1079

What is the precedence of stage variables,derivations, and constraints?

1031

What is "fatal error/rdbms code 3996" error?

1195

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1141

Differentiate between Join, Merge and Lookup stage?

1039

Define repository tables in datastage?

1101

Where the datastage stored his repository?

1019

How do you import and export data into datastage?

1169

What is the differentiate between data file and descriptor file?

1307

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2045

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