Primary Key is a combination of unique and not null. DSWait For File Checks if a BASIC routine is cataloged, either in VOC as a callable item, or in the catalog space. (Oconv) ________________________________________ DATASTAGE FAQ from GEEK INTERVIEW QUESTIONS ________________________________________ Question: Dimension Modeling types along with their significance Answer: Data Modelling is broadly classified into 2 types. Most importance of using it is, it is independent of underlying database, i.e. DSTranslate Code Suspend a job until a named file either exists or does not exist. Question: Dimensional modelling is again sub divided into 2 types. Answer: Surrogate Key is a Primary Key for a Dimension table. Question: How to handle Date convertions in Datastage? Answer: We use a) "Iconv" function - Internal Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]") Question: Types of Parallel Processing? Question: What does a Config File in parallel extender consist of? Link Collector: It collects the data coming from partitions, merges it into a single data flow and loads to target.
Data Stage Manager: We can view and edit the Meta data Repository. We can export the Data stage components in or format. s properties and allows other jobs to be run and controlled from the first job. Specify the job you want to control DSAttach Job Set parameters for the job you want to control DSSet Param Set limits for the job you want to control DSSet Job Limit Request that a job is run DSRun Job Wait for a called job to finish DSWait For Job Gets the meta data details for the specified link DSGet Link Meta Data Get information about the current project DSGet Project Info Get buffer size and timeout value for an IPC or Web Service stage DSGet IPCStage Props Get information about the controlled job or current job DSGet Job Info Get information about the meta bag properties associated with the named job DSGet Job Meta Bag Get information about a stage in the controlled job or current job DSGet Stage Info Get the names of the links attached to the specified stage DSGet Stage Links Get a list of stages of a particular type in a job.
We can declare stage variable in transform, we can call routines, transform, macros, functions. Its input type is literal string & output type is string. Active stages model the flow of data and provide mechanisms for combining data streams, aggregating data, and converting data from one data type to another. Data Stage BASIC functions: These functions can be used in a job control routine, which is defined as part of a job?
DSTransform Error Convert a job control status or error code into an explanatory text message. B) Snowflake Schema - Complex with more Granularity. Question: Importance of Surrogate Key in Data warehousing?
DSSend Mail Log a warning message to a job log file.
Q 21 What are Ascential Dastastage Products, Connectivity Ans: Ascential Products Ascential Data Stage Ascential Data Stage EE (3) Ascential Data Stage EE MVS Ascential Data Stage TX Ascential Quality Stage Ascential Meta Stage Ascential RTI (2) Ascential Profile Stage Ascential Audit Stage Ascential Commerce Manager Industry Solutions Connectivity Files RDBMS Real-time PACKs EDI Other Q 22 Explain Data Stage Architecture? DSMake Job Report Insert arguments into the message template.
DSLog Warn Generate a string describing the complete status of a valid attached job. Explain Star-Schema and Snowflake Schema with difference.
While using Hash partition we specify the Partition Key.
It can be a collection of key values called as composite primary key. There are several methods of partition like Hash, DB2, Random etc...
Answer: As the names itself suggest what they mean. The Data file has a default size of 2GB and the overflow file is used if the data exceeds the 2GB size. Question: Compare and Contrast ODBC and Plug-In stages? Question: What are OConv () and Iconv () functions and where are they used? Question: Functionality of Link Partitioner and Link Collector?
Derivation - Expression that specifies value to be passed on to the target column. B) Dynamic - sub divided into 2 types i) Generic ii) Specific Default Hased file is "Dynamic - Type Random 30 D" Question: What are Static Hash files and Dynamic Hash files? Answer: Container is a collection of stages used for the purpose of Reusability. A) Local Container: Job Specific B) Shared Container: Used in any job within a project. Answer: By using "Excec SH" command at Before/After job properties.
DSPrepare Job Interface to system send mail facility.