Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

can explain wt is the pool for file.

CTS,

1 7040

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?

IBM,

1 7278

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

IBM,

2 8022

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?

IBM,

1 5643

How to transfer file from one system to another system in UNIX?which command to be use?

Cap Gemini, TCS,

4 12403

How to create a doccument in datastage?

Cap Gemini,

1 7868

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

Reliance,

2491

What is the function in Transformer stage can act as Rank Function in oracle

Reliance,

1 6791

How can we do null handling in sequential files

Reliance,

3 15692

on how many columns we can perform aggregation in the aggregator stage?

Reliance,

2 6896

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

Syntel,

2330

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?

HCL,

2281

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

TCS,

7 33703

What is PX?

IBM,

2 7261

what is time dimension? and how to populate time demension

TCS,

2 11804

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is use Array size in datastage

1825

What are the difference types of stages?

1287

What is job control?

1197

How the ipc stage work?

1170

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074

Terminate Activity

1338

what are the devoleper roles in real time? plz tell i am new to datastage....

2212

How do you import and export the datastage jobs?

1209

Notification Activity

1460

What is ibm datastage?

1022

What is difference between join, merge and lookup stage?

1149

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

2330

What are the types of containers in datastage?

1226

What is the difference between datastage and informatica?

1185

How many types of views are there in a datastage director?

1340

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