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 6961

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 7206

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 7915

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 5572

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

Cap Gemini, TCS,

4 12220

How to create a doccument in datastage?

Cap Gemini,

1 7784

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

Reliance,

2446

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

Reliance,

1 6711

How can we do null handling in sequential files

Reliance,

3 15544

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

Reliance,

2 6801

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

Syntel,

2293

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,

2230

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 33425

What is PX?

IBM,

2 7150

what is time dimension? and how to populate time demension

TCS,

2 11698

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188

What is active and passive stage?

1414

How a source file is populated?

1066

What is the process of killing a job in datastage?

1020

Why do you need stage variables?

1180

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2865

Describe stream connector?

1307

What is the difference between datastage and datastage tx?

1066

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3794

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

1153

explain about citrix scheduling tool in datastage

2457

If you want to use the same piece of code in different jobs, how will you achieve it?

1155

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2224

What are the different common services in datastage?

1284

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