where we use config file as parameter ?
datastage depends on configuration file.
Well if u know abt of configuration file then here i go with
the ans...
APT_CONFIG_FILE is the environment variable using which
datastage determine the configuration file.That will give us
an option to mention our designed configuration file instead
of default.apt which is default configuration file. And one
can have many configuration files for a project to be used.
In any job at job properties- properties tab we will be
asked to give name parameter name and its corresponding
default value.
However we will select $APT_CONFIGURATION_FILE and to use
our designed configuration file we mention that in Default
value column. So in that way we use config file as parameter.
Thats it.
| Is This Answer Correct ? | 2 Yes | 0 No |
What steps should be taken to improve Datastage jobs?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Give an idea of system variables.
How to move data set from one server to other?what are the steps to follow to do this?
What are the different type of jobs in datastage?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
Wat is pre-load in Hashed file
Explain the scenarios where sequential file stage runs in parallel?
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
Can you explain players in datastage?