Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

Hi This is Vijay, How can your remove the duplicates in sequential File?

HCL, Scope International,

15 31415

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

Semantic Space,

8 13767

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 12538

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

TCS,

5 12738

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

CTS,

6 17772

What's the Main Function of the Staging area in DWH

Oracle,

3 14565

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

Scope International,

15 34057

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

IBM,

2409

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

IBM,

1 8787

what is advantages of snowflake when it is used?

IBM,

3 8348

Hi Vijay here For Four CPU's how many nodes will required?

TCS,

4 11632

wt is the difference between swith and filter stage

IBM,

6 19516

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

IBM,

1 12246

in aggregator , how can i get the sum in readable format

IBM,

4 10347

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 25288

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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

1200

How to find value from a column in a dataset?

2250

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

1211

If you want to use the same piece of code in different jobs, how will you achieve it?

1218

what is flow of project?

2057

Where the datastage stored his repository?

1140

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3523

Differentiate between odbc and drs stage?

1103

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3810

What is the difference between Datastage 7.5 and 7.0?

1151

What is difference between server jobs & parallel jobs?

1089

Which warehouse using in your datawarehouse

2235

Define data aggregation?

1148

How rejected rows are managed in datastage?

1575

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

1306

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