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 31000

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 13520

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

1 12444

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 12544

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

CTS,

6 17511

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

Oracle,

3 14445

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 33540

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,

2356

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 8706

what is advantages of snowflake when it is used?

IBM,

3 8218

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

TCS,

4 11488

wt is the difference between swith and filter stage

IBM,

6 19337

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 12166

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

IBM,

4 10203

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 25131

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085

Can you explain repository tables in datastage?

1407

What all the types of jobs you developed?

1180

What is the purpose of pivot stage?

1168

What are the types of views in datastage director?

1772

What are the types of jobs we have in datastage?

1075

Explain the importance of surrogate key in data warehousing?

1190

What are iconv and oconv?

1241

Describe the architecture of datastage?

1008

Lookup constraints

1254

Differentiate between hash file and sequential file?

1072

What are the partitioning techniques available in link partitioner?

2278

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463

What are the different layers in the information server architecture?

1124

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2293

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