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 31411

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 13766

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

1 12537

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 12737

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

CTS,

6 17771

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

Oracle,

3 14564

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 34052

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 8786

what is advantages of snowflake when it is used?

IBM,

3 8343

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