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 8665

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

2 7443

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 6019

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

IBM,

2 49296

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

TCS,

2 9767

where we use column generator stage in real time scenario?

TCS,

5 26883

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

5 22750

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 11291

which cache supports connected & un connected Lookup

Wipro,

1 5766

can we use sequential file as a lookup

Cognizant, Wipro,

7 24090

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 7292

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

Accenture, Wipro,

3 23570

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 8937

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 8707

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,

2470

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How we can covert server job to a parallel job?

1138

Differentiate between data file and descriptor file?

1049

What is staging variable?

1084

How do you remove duplicate values in datastage?

1149

Describe stream connector?

1305

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

1411

Define Job control?

1138

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3746

What are some prerequisites for datastage?

1093

What is the difference between the local container and shared container?

1096

What are datastage sequences?

1116

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3343

What is the flow of loading data into fact & dimensional tables?

1059

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

2079

How can one find bugs in job sequence?

1385

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