Tuesday
Ascential Data Stage FAQ's
Q. What is the architecture of Data Stage
A. Client Server Architecture
Q. What are the components of Client and explain them?
A.Designer, Director, Manager, Administrator
Q.What is the difference between ODBC Stage and OCI Stage
A. In ODBC Stage user can connect to any data base and through OCI Stage user can connect to Oracle Database only. If user uses ODBC Stage than DSN name should be create in Data Source.
Q.What is a Passive and Active Stage? Give Example
A. If the data changes from in put to out put than it is an active stage else it is a passive stage. Transformer Stage is an Active stage while Hash Stage is a passive stage.
Q.How to find the length of a String?
A. By using Len function user can find out the length of the sting.
Q.What is the format for if-Else Block
A. If Column1 > 100 Then "A" Else "B"
Q.How do u concatenates two values.
A. The concatenation operator is “:”
Q.Where you define the job parameter.
A. The job parameter is defined in the job->Edit->job Properties. Than click the Job Parameter Menu.
Q.How to use the parameter in a job?
A. To use the defined job parameters, you must specify them when you edit a stage. When you edit any of the fields for which you wish to use a parameter, enter #Param#, where Param is the name of the job parameter.
Q.How to convert the string into uppercase.
A. To convert the string into uppercase we need to use UPCASE function
E.g. String a=My Value;
UPCASE (a) =MYVALUE;
Q.But how to convert lower case?
A. DOWNCASE (a) =my value;
Q.How to get a substring from a string.
A. String a=My Value;
If user wants first three character than the function is
Substrings (a, 1, 3);
Q.How do u schedules a job?
Q.How to create a sequence in Data stage job?
A. By using the KeyMgtGetNextValue.This is present in the category SDK/KeyMgt
Q.How many number of input link will be used in transformer stage?
A. Transformer stages in server jobs can have one primary input link, but there can be any number of reference inputs.
Q.What is the use of Transformer Stage?
A. Transformer stages do not extract data or write data to a target database. They are used to handle extracted data, perform any conversions required, and pass data to another Transformer stage or a stage that writes data to a target data table.
Q.Where user can write custom routine?
A. The user can write custom routine in Manager.
Q.Have ever writes any routine? If yes explain.
Q.What is the difference between Stage Variable and System Variable?
A.DataStage provides a set of variables containing useful system information that you can access from a transform or routine. System variables are read-only. All System Variable starts with @.Some of the System variables are
@DATE the internal date when the program started. See the Date function.
@DAY The day of the month extracted from the value in @DATE.
@FALSE The compiler replaces the value with 0.
@INROWNUM Input row counter. For use in constrains and derivations in Transformer stages.
@OUTROWNUM Output row counter (per link). For use in derivations in Transformer stages.
@LOGNAME The user login name.
@MONTH The current extracted from the value in @DATE.
@NULL the null value.
@NULL.STR The internal representation of the null value, Char (128).
@NUMPARTITIONS In a parallel Transformer stage output derivation gives the total number of partitions for the stage.
@PARTITIONNUM In a parallel Transformer stage output derivation gives the partition number for the particular instance.
@PATH The pathname of the current Data Stage project.
@SCHEMA The schema name of the current Data Stage project.
@SM A sub value mark (a delimiter used in UniVerse files), Char(252).
@SYSTEM.RETURN.CODE
Status codes returned by system processes or commands.
@TIME The internal time when the program started. See the Time function.
@TM A text mark (a delimiter used in UniVerse files), Char(251).
@TRUE The compiler replaces the value with 1.
@USERNO The user number.
@VM A value mark (a delimiter used in UniVerse files), Char(253).
@WHO The name of the current DataStage project directory.
@YEAR The current year extracted from @DATE.
But Stage variables created by the user. It executes first while running.It is defined inside the transformer stage. In this user will see the stage varaible window and he can defines there.
