DB Administration interview questions – page 12

What is the difference between datastage and informatica

If I add a new environment variable in Windows, how can I access it in DataStage?

How to implement routines in data stage,have any one has any material for data stage pl send to me

Where actually the flat files store?what is the path?

Differentiate Database data and Data warehouse data?

What is the order of execution done internally in the transformer with the stage editor having input links on the lft hand side and output links?

What are the various file formats involved in reportnet?

What are OConv () and Iconv () functions and where are they used?

What is NLS in datastage?

Importance of Surrogate Key in Data warehousing?

If your running 4 ways parallel and you have 10 stages on the canvas, how many processes does datastage create?

How does DataStage handle the user security?

What are the command line functions that import and export the DS jobs?

What are versions of reportnet?

What are the Job parameters?

How can ETL excel file to Datamart?

Can report net connect multiple datasource at a time in report creation time

DataStage from Staging to MDW is only running at 1 row per second! What do we do to remedy?

Functionality of Link Partitioner and Link Collector?

What is iconv and oconv functions?

Maximum how many characters we can give for a Job name in DataStage?

How do you define a cube?

How can we limit the max no of rows retrieved in the report?

Explain in detail about type 1,type 2(SCD),type 3 ?

What are all the third party tools used in DataStage?

What are the Steps involved in development of a job in DataStage?

What is the max capacity of Hash file in DataStage?

What is Hash file stage and what is it used for?

What are Static Hash files and Dynamic Hash files?

Your client wants to ensure only specific users can create reports in Query Studio with other users creating reports using Report Studio. How can this be accomplished?