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 5350

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

IBM,

1 4282

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

IBM, YCS,

3 6780

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 8278

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

2 6344

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 7663

What is the difference between Link collector and Funnel Stages?

1 7210

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 4589

count number of deptno in a emp table?

IBM,

2 5406

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

IBM, TCS,

1 4786

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 10173

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

HSBC,

2 6414

what is flow of project?

HSBC, IBM,

1996

explain about citrix scheduling tool in datastage

HSBC,

2446

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

HSBC,

2 6332

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How to Remove Duplicate using SQL?

1360

What are datastage sequences?

1116

Why we use surrogate key?

1227

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2240

Which commands are used to import and export the datastage jobs?

1411

What are the types of hashed files in data stage

1106

What all are the different way to run a job?

1090

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?

1033

Describe routines in datastage? Enlist various types of routines.

1008

What is meta stage?

1174

Give an idea of system variables.

1018

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

1150

Differentiate between datastage and informatica?

1179

What are the enhancements made in datastage 7.5 compare with 7.0?

1146

Can you explain kafka connector?

1303

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