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 8777

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

2 7596

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 6122

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

IBM,

2 49407

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

TCS,

2 9878

where we use column generator stage in real time scenario?

TCS,

5 27087

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

5 22971

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 11478

which cache supports connected & un connected Lookup

Wipro,

1 5874

can we use sequential file as a lookup

Cognizant, Wipro,

7 24371

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 7387

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

Accenture, Wipro,

3 23746

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 9066

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 8800

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,

2532

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the different type of jobs in datastage?

1024

Can you explain repository tables in datastage?

1453

what is the use of materialized view?

1635

What is the difference between server job and parallel jobs?

1198

what is repositery?

1927

Can you filter data in hashed file?

3825

What are system variables and sequencers in datastage

1177

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1600

What are constraints and derivations?

1210

What is difference between join, merge and lookup stage?

1149

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

3181

client know skid info?

2134

Differentiate between datastage and informatica?

1248

Can you highlight the main features of ibm infosphere information server?

1125

What is process model?

2022

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