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 30933

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 13496

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

1 12437

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 12528

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

CTS,

6 17503

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

Oracle,

3 14433

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 33492

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,

2350

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 8698

what is advantages of snowflake when it is used?

IBM,

3 8209

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

TCS,

4 11478

wt is the difference between swith and filter stage

IBM,

6 19314

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 12158

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

IBM,

4 10187

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 25113

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the processing stages?

1095

How to manage date conversion in Datastage?

1132

Could anyone give brief explanation bout datastage admin

2350

In Datastage, how you can fix the truncated data error?

1155

Can you explain repository tables in datastage?

1399

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2054

What is a folder? Difference types of stages?

1169

How complex jobs are implemented in datstage to improve performance?

1036

What is the differentiate between data file and descriptor file?

1356

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1375

Can you explain tagbatch restructure operator?

1168

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

2965

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2240

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)

917

What is the use of datastage designer?

1150

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