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 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?

IBM,

2173

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

Teradata,

6 12968

how many write modes are there in ds

IBM,

2 11439

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

Gallega, TCS,

5 15087

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14241

difference between function and procedure...

IBM,

1 6200

if ename='subbu' while running job the job should be abort how come?

IBM,

3 8638

how to find diff between 2 dates without using Icon... funtions?

1 3642

how to find no.of records in sequntial file itself?

4 21656

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 6007

ename like ibm,tcs,hcl need display those records only how?

2 6425

convert yyyy mm dd to dd mm yyyy?

4 16211

how to closeing records after 10,000 records come?

3 6356

how to add a new records into source?

1996

in oracle target stage when we use load option and when we use upsert option?

2277

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between in process and inter process?

1139

What are some different alternative commands associated with "dsjob"?

1165

What are the important features of datastage?

1119

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

2718

What are system variables and sequencers in datastage

1115

what is flow of project?

1996

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4036

What are datastage sequences?

1116

To see hidden files in LINIX?

1520

Can you explain how could anyone drop the index before loading the data in target in datastage?

1502

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

1060

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

1411

What are the main differences you have observed between 7.x and 8.x version of datastage?

1081

AGGREGATOR default datatype

1456

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2290

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