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 5364

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

IBM,

1 4296

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

IBM, YCS,

3 6794

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 8289

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

2 6355

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 7675

What is the difference between Link collector and Funnel Stages?

1 7217

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 4597

count number of deptno in a emp table?

IBM,

2 5417

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

IBM, TCS,

1 4794

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 10188

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

HSBC,

2 6419

what is flow of project?

HSBC, IBM,

2002

explain about citrix scheduling tool in datastage

HSBC,

2457

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

HSBC,

2 6341

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the various kinds of the hash file?

1149

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

How to find value from a column in a dataset?

2203

Can you explain engine tier in information server?

1135

What is size of a transaction and an array means in a datastage?

1313

Can you explain players in datastage?

1199

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

Define Data Stage?

1091

what are the devoleper roles in real time? plz tell i am new to datastage....

2162

What is the use of hoursfromtime() function in transformer stage in datastage?

1068

Where the datastage stored his repository?

1089

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2179

What is data partitioning?

1202

Notification Activity

1398

Explain entity, attribute and relationship in datastage?

1101

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