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,

2138

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 12765

how many write modes are there in ds

IBM,

2 11333

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

Gallega, TCS,

5 14879

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14027

difference between function and procedure...

IBM,

1 6125

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

IBM,

3 8515

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

1 3587

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

4 21481

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

1 5935

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

2 6316

convert yyyy mm dd to dd mm yyyy?

4 16038

how to closeing records after 10,000 records come?

3 6202

how to add a new records into source?

1940

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

2210

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the command line function to import and export the ds jobs?

1102

Define meta stage?

1150

What is the difference between informatica and datastage?

1154

How do you schedule or monitoring the job?

1144

Explain how a source file is populated?

1320

what is the use of materialized view?

1500

How the ipc stage work?

1087

Describe routines in datastage? Enlist various types of routines.

956

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2397

how many rows sorted in sort stage by default in server jobs

3940

How many areas for files does datastage have?

1090

which r the connectors used in san?

2150

options available in sequence job to run,validate?

1264

What is the difference between odbc and drs stage?

1052

What are stage variables?

1145

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