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,

2225

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 13176

how many write modes are there in ds

IBM,

2 11561

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

Gallega, TCS,

5 15337

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14448

difference between function and procedure...

IBM,

1 6300

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

IBM,

3 8817

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

1 3732

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

4 21830

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

1 6086

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

2 6557

convert yyyy mm dd to dd mm yyyy?

4 16403

how to closeing records after 10,000 records come?

3 6492

how to add a new records into source?

2055

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

2323

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2780

How many types of stage?

1227

What is the differentiate between data file and descriptor file?

1412

How do you schedule or monitoring the job?

1266

What is the difference between an operational datastage and a data warehouse?

1210

How do you import and export the datastage jobs?

1209

what is 'reconsideration error' and how can i respond to this error and how to debug this

2675

What is the use of datastage director?

1073

Can you implement SCD2 using join, transformer and funnel stage?

1604

How to reverse the string using SQL?

1593

What is the difference between operational data stage (ods) and data warehouse?

1294

How do you start developing a datastage project?

1160

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

4050

Give an idea of system variables.

1090

which r the connectors used in san?

2229

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