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,

2179

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 12999

how many write modes are there in ds

IBM,

2 11459

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

Gallega, TCS,

5 15122

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14263

difference between function and procedure...

IBM,

1 6213

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

IBM,

3 8652

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

1 3653

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

4 21680

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

1 6016

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

2 6434

convert yyyy mm dd to dd mm yyyy?

4 16237

how to closeing records after 10,000 records come?

3 6366

how to add a new records into source?

2000

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

2285

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the steps needed to create a simple basic datastage job?

1235

What are constraints and derivations?

1170

Enlist various types of routines in datastage.

1256

Describe link sort?

1013

Can you explain link buffering?

1179

What are the differences between datastage and informatica?

1177

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1227

What are the types of containers?

1237

On which interface you will be working as a developer?

1043

What is merge stage?

1314

How do you generate sequence number in datastage?

1094

Name the different types of Lookups in Datastage?

1259

Difference between server jobs & parallel jobs?

1077

Name the command line functions to import and export the DS jobs?

1156

How to read the length of word in unix?

1380

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