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...

Which Describes the default behaviour when you create a table in SQL?

The table is accessible to all users. Tables are created in the public Schema. Tables are created in your schema. Tables are created...

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...

Datastage Real time scenario Transformer Stage Question

If I have a Source like below a,b,c,1,2,3 ( All  of them are in 1 column ) If I want to get output as below a,b,c,1 (...

What is Missing file Mode in Datastage

Specific the action to be taken if the file is missed.  a) Depend ( the default is Error unless the file name has a node...

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...

Overview: Best Practices of Datastage

This Section Provides an Overview of recommendations for standard practices.  The recommendations are categorized as follows.  a) Standards b) Development Guidelines  c) Component Usage  d) Datastage Data Types  e) Partitioning...

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...

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...

Change Apply Stage

The change Apply Stage is a Processing stage. It has two input links and one output link. The two input links are the "change"...