Blog Posts - Datastage Interview Questions



Remove Duplicate Stage Properties

Key: Specifies the colun that defines duplicates. The key can be selected from the drop down key columns . Duplicate to retain: Specifies which of the duplicate columns encountered to retain choose between first and last. It is set to...
by Datastage on Aug 20, 2015

Encode/Decode and Compress/Expand Stages

Encode and Compress stages are processing stages that are used to encode/compress a data set using UNIX encoding command. Commands such as 'gzip' can be used. It converts an input data set from a sequence of records to a stream of raw binary data. Th...
by Datastage on Aug 20, 2015

Oracle Stage Output Properties

Table: Name of the Oracle Table. Write Method: The available write methods are: Delete ( to delete rows in the target table) Load ( to load the data in the target table) Upset ( to perform an update & insert operation) Wr...
by Datastage on Aug 19, 2015

Oracle Stage Output Properties

Table: Name of the Oracle Table. Write Method: The available write methods are: Delete ( to delete rows in the target table) Load ( to load the data in the target table) Upset ( to perform an update & insert operation) Wr...
by Datastage on Aug 19, 2015

SAS Parallel Data Set Stage

The SAS Parallel Data Set Stage is a file stage. It allows reading data from or writing data to a parallel SAS data set in Conjunction with an SAS Stage. The stage can have a single input link or a single output link . It can be configured o execute...
by Datastage on Aug 18, 2015

What is Peek Stage in Datastage ?

The peek stage is a development/debug stage. It can have a single input link and any number of output links. The peek stage can be used to print the record column values to the job log or to a separate output link as it copies records from its input...
by Datastage on Aug 18, 2015

Peek Stage Properties

All Records ( After Skip) : Set to true to print all the records from each partition. By default it is set to face. Number of records( Per partition) : Specifies number of records to print for each partition. The default is 1...
by Datastage on Aug 18, 2015

Peek Stage Properties

All Records ( After Skip) : Set to true to print all the records from each partition. By default it is set to face. Number of records( Per partition) : Specifies number of records to print for each partition. The default is 1...
by Datastage on Aug 18, 2015

SAS Parallel Data Set Stage

The SAS Parallel Data Set Stage is a file stage. It allows reading data from or writing data to a parallel SAS data set in Conjunction with an SAS Stage. The stage can have a single input link or a single output link . It can be configured o execute...
by Datastage on Aug 18, 2015

What is Peek Stage in Datastage ?

The peek stage is a development/debug stage. It can have a single input link and any number of output links. The peek stage can be used to print the record column values to the job log or to a separate output link as it copies records from its input...
by Datastage on Aug 18, 2015

Topologies Supported in Datastage

Datastage Parallel Extender is built on a highly scalable parallel software architecture that delivers high levels of through =out and performance. For maximum scalability, integration spftware must do more than run on symmetric multiprocessing ( SMP...
by Datastage on Aug 17, 2015

Topologies Supported in Datastage

Datastage Parallel Extender is built on a highly scalable parallel software architecture that delivers high levels of through =out and performance. For maximum scalability, integration spftware must do more than run on symmetric multiprocessing ( SMP...
by Datastage on Aug 17, 2015

What is Datastage Keep File Partitions

Set True to Partition the read data set according to the organization of the input File. Usually, setting "True" allows better performance in subsequent stages. However, it is not desirable if the input file already has sort in a certain order. ...
by Datastage on Aug 13, 2015

What is the Datastage Expression Editor

 Expression Editor helps you to enter the correct expressions when you edit the transformer stages. a)     Facilitate the entry of the expression elements. b)     Compare the names of the frequen...
by Datastage on Aug 13, 2015

What is the Datastage Expression Editor

 Expression Editor helps you to enter the correct expressions when you edit the transformer stages. a)     Facilitate the entry of the expression elements. b)     Compare the names of the frequen...
by Datastage on Aug 13, 2015

What is Datastage Keep File Partitions

Set True to Partition the read data set according to the organization of the input File. Usually, setting "True" allows better performance in subsequent stages. However, it is not desirable if the input file already has sort in a certain order. ...
by Datastage on Aug 13, 2015

All About Generic Stage in Datastage

The Generic Stage is a  Processing Stage. It has any number of input links and any number of Outpu links. The generic Stage allows you to call on Orchestrate Operator from with in a Datastage Stage and Pass it options a required. ...
by Datastage on Aug 12, 2015

All About XML Output Stage

The XML Output Stage is used to convert tabular data such as tables and sequential files to XML hierarchical structures. XML Output stage supports single input link and zero or more output links. The XML Output stage required X-Path expressions to tr...
by Datastage on Aug 12, 2015

Overview:Best Practices of Datastage

This Section Provides an Overview of recommendations for standard practices. The recommendations are categorized as follows. a) Standardsb) Development Guidelines c) Component Usage d) Datastage Data Types e) Partitioning Dat...
by Datastage on Aug 12, 2015

Standards of Datastage

It is important to establish and follow consistent standards in: 1) Directory Structures for installation and application support directories. 2) Naming Conventions, especially for Datastage project categories stage, names and links. 3) All DataStage...
by Datastage on Aug 12, 2015


Trending Topics

Close