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 12997

how many write modes are there in ds

IBM,

2 11457

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

Gallega, TCS,

5 15117

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14261

difference between function and procedure...

IBM,

1 6207

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

IBM,

3 8650

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

1 3652

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

4 21677

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 6432

convert yyyy mm dd to dd mm yyyy?

4 16234

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 }

how to abort the job its matain duplicates?

2574

What are the types of hashed files in data stage

1108

How many Key we can define in remove duplicate stage?

1383

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2967

How many types of sorting methods are available in datastage?

1073

What is the difference between datastage and datastage tx?

1065

What is difference between join, merge and lookup stage?

1095

CHANGE CAPTURE

1299

Define orabulk and bcp stages?

1122

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

What is a folder? Difference types of stages?

1175

What is active and passive stage?

1413

I have a few records just I want to store data in to targets cycling way how?

2359

Have you have ever worked in unix environment and why it is useful in datastage?

1133

On which Dimension Table you implemented SCD Type in your Project

2042

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