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 5782

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 23592

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 8949

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 }

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1225

What is ibm datastage flow designer?

1149

Enlist various types of routines in datastage.

1255

Whats difference betweeen operational data stage (ods) and data warehouse?

1114

Can we use target hash file as a lookup ?

3326

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1415

What is ds designer?

1103

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

What is a quality stage in datastage tool?

1075

How to read the length of word in unix?

1380

How can you write parallel routines in datastage PX?

1015

Why fact table is in normal form?

1249

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

2131

What are the types of containers in datastage?

1191

Name the command line functions to import and export the DS jobs?

1155

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