Data Stage

DataStage Interview Questions and Answers,Solution and Explanation - Part 14

What are the Environmental variables in Datastage?

How do you check for Job Errors in Datastage

What are Stage Variables, Derivations and Constants?

What is Pipeline Parallelism?

Which version of Datastage did you use and what are the features in it?

Why do we use a transformer?

What are different schemas you have used in your project ?

What was the intention of choosing one schema over another ?

DataStage Interview Questions and Answers,Solution and Explanation - Part 13

What is the difference between IBM Web Sphere Datastage 7.5 (Enterprise Edition ) & Standard Ascential?

How do you remove duplicates in dataset

What is the difference between Job Control and Job Sequence

What is the max size of Data set stage?

How do you measure performance in sort stage

How to develop the SCD using LOOKUP stage?

What are the errors you experienced with data stage

DataStage Interview Questions and Answers,Solution and Explanation - Part 12

How do we create index in Datasatge?

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

What is a sequential file that has single input link?

What is hashing algorithm?

What is Orchestrate options in generic stage, what are the option names. value ? Name of an Orchestrate operator to call.

How do you fix the error "OCI has fetched truncated data" in Datastage

DataStage Interview Questions and Answers,Solution and Explanation - Part 11

Data Warehouse Interview Questions,Live DataStage Tool Interview Questions.

What are Static Hash files and Dynamic Hash files?

What is the difference between Datastage Server jobs and Datastage Parallel jobs?

What is ' insert for update ' in Datastage

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?

DataStage Interview Questions and Answers,Solution and Explanation - Part 10

Overview:Data Warehousing Interview Questions,DataStage Interview Questions asked in HCL,Wipro,TCS,Infosys,Tech Mahindra,Patni,Sasken,Birlasoft

What is iconv and oconv functions?

What is project life cycle and how do you implement it?

For what purpose is the Stage Variable is mainly used?

Explain the purpose of using the key and difference between Surrogate keys and natural key

DataStage Interview Questions and Answers,Solution and Explanation - Part 9

How to drop the index before loading data in target and how to rebuild it in Datastage?

How can ETL excel file to Datamart?

What is the transaction size and array size in OCI stage?how these can be used?

What is job control? How it is developed? Explain with steps?

What is the purpose of exception activity in Datastage 7.5?

Other than Round Robin, What is the algorithm used in link collecter? Also Explain How it will works?

DataStage Interview Questions and Answers,Solution and Explanation - Part 8

What is merge and how it can be done Please explain with simple example taking 2 tables?

Is it possible to run parallel jobs in server jobs?

What are the enhancements made in Datastage 7.5 compare with 7.0

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

What is OCI?

Is it possible to move the data from oracle ware house to SAP Warehouse using with Datastage Tool.

How can we create Containers?

DataStage Interview Questions and Answers,Solution and Explanation - Part 5

What is the importance of Surrogate Key in Data warehousing?
Ans :
Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database

What does a Config File in parallel extender consist of?
Ans:
Config file consists of the following. a) Number of Processes or Nodes. b) Actual Disk Storage Location.