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

Data Stage Interview Questions

Questions Answers Views Company eMail

What are the environmental settings for data stage,while working on parellel jobs?

Satyam,

2 8555

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 7312

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 5916

how to design the change capture stage in(data stage parallel jobs) type 2

IBM,

2 49170

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

TCS,

2 9661

where we use column generator stage in real time scenario?

TCS,

5 26663

How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 22564

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 11148

which cache supports connected & un connected Lookup

Wipro,

1 5691

can we use sequential file as a lookup

Cognizant, Wipro,

7 23848

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

Wipro,

1 7207

what is Audit table?Have u use audit table in ur project?

Accenture, Wipro,

3 23405

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

Wipro,

2 8814

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

Wipro,

2 8609

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

TCS,

2406

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3079

How many types of sorting methods are available in datastage?

1020

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2328

What are the important features of datastage?

1052

What is oci?

1262

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1371

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1687

How do you start developing a datastage project?

1059

What are constraints and derivations?

1116

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

1233

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

2046

explain about citrix scheduling tool in datastage

2384

Where the datastage stored his repository?

1020

Differentiate between odbc and drs stage?

1000

What is datastage?

1031

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