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 8678

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

2 7461

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 6035

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

IBM,

2 49307

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

TCS,

2 9779

where we use column generator stage in real time scenario?

TCS,

5 26918

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

5 22772

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 11332

which cache supports connected & un connected Lookup

Wipro,

1 5781

can we use sequential file as a lookup

Cognizant, Wipro,

7 24115

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 7301

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

Accenture, Wipro,

3 23591

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 8947

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 8716

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,

2479

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

root tree will find which is server job and which is parallel job?

1967

What are datastage sequences?

1118

Can you explain repository tables in datastage?

1407

How many areas for files does datastage have?

1152

What are stage variables?

1201

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463

How do you remove duplicate values in datastage?

1151

How do u convert the columns to rows in datastage?

1194

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

1100

What are the functionalities of link partitioner?

1022

How do you import and export the datastage jobs?

1159

What is quality stage?

987

What are the job parameters?

1221

What steps should be taken to improve Datastage jobs?

1073

What are the enhancements made in datastage 7.5 compare with 7.0?

1148

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