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 7205

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 7913

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 12215

How to create a doccument in datastage?

Cap Gemini,

1 7783

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

Reliance,

2444

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

Reliance,

1 6709

How can we do null handling in sequential files

Reliance,

3 15539

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,

2228

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 33424

What is PX?

IBM,

2 7149

what is time dimension? and how to populate time demension

TCS,

2 11698

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

what is the use of skid in reporting?

2381

Which commands are used to import and export the datastage jobs?

1412

What are orabulk and bcp stages?

1124

What are system variables and sequencers in datastage

1115

What is the difference between orabulk and bcp stages?

1025

Define Data Stage?

1091

What are the primary usages of datastage tool?

1072

What is the different type of jobs in datastage?

974

project Steps,hits, Project level HArd things,Solved methods?

2131

Can you explain kafka connector?

1311

What are the processing stages?

1099

Explain how a source file is populated?

1364

How one source columns or rows to be loaded in to two different tables?

1130

Can we use target hash file as a lookup ?

3326

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

932

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