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 30456

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 13261

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

1 12342

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 12324

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

CTS,

6 17315

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

Oracle,

3 14264

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 32881

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,

2311

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 8608

what is advantages of snowflake when it is used?

IBM,

3 8072

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

TCS,

4 11286

wt is the difference between swith and filter stage

IBM,

6 19088

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 12082

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

IBM,

4 9985

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 24909

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

what is flow of project?

1932

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

1096

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

3929

What are the main features of datastage?

1206

What are the types of containers and how to create them?

931

Terminate Activity

1231

What are iconv and oconv?

1181

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2169

What are the types of views in datastage director?

1720

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

887

What is a merge?

1076

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1833

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2444

How to clean the datastage repository?

1069

Is possible to create skid in dim,fact tables?

2587

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