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 31032

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 13538

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

1 12451

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 12567

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

CTS,

6 17528

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

Oracle,

3 14453

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 33590

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,

2358

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 8709

what is advantages of snowflake when it is used?

IBM,

3 8230

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

TCS,

4 11494

wt is the difference between swith and filter stage

IBM,

6 19347

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 12175

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

IBM,

4 10211

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 25141

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Define orabulk and bcp stages?

1126

What is the importance of the exception activity in datastage?

1073

What are transforms and what is the differenece between routines and transforms?

1066

How complex jobs are implemented in datstage to improve performance?

1043

Have you have ever worked in unix environment and why it is useful in datastage?

1134

Describe routines in datastage? Enlist various types of routines.

1016

What are the functionalities of link partitioner?

1022

What is the use of hoursfromtime() function in transformer stage in datastage?

1070

How many types of hash files are there?

1185

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

1153

Is it possible to query a hash file?

2013

How do you remove duplicate values in datastage?

1156

What are the different type of jobs in datastage?

1045

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2048

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2238

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