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 ?
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
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
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?
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
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?
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?
How can you do incremental load in Datastage? How we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? Explain briefly? What is APT_CONFIG in Datastage How do we do the automation of dsjobs?
What is trouble shhoting in server jobs ? what are the diff kinds of errors encountered while running any job?
What is Datastage Multi-byte, Single-byte file conversions?how we use that conversions in Datastage?
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.
What versions of DS you worked with?
Ans: DS 7.0.2/6.0/5.2
If worked with DS6.0 and latest versions what are Link-Partitioner and Link-Collector used for?
Ans: Link Partitioner - Used for partitioning the data.Link Collector - Used for collecting the partitioned data.
