How to use Environment variable's in datastage?(use of process)
To use environment variable at the project or job level, we
should first check if the environment variable already
present at the project level. If the environment variable
does not exist, we should create the one and then it should
be used at the project level or at the job level.
To use the environment variable you just need to add to the
project or job.
| Is This Answer Correct ? | 2 Yes | 3 No |
how to sort two columns in single job in datastage.
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
How do you get log info into a file?
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.
What steps should be taken to improve Datastage jobs?
How to enter a log in auditing table whenever a job get finished?
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
What is the process of killing a job in datastage?
How can you join flat file, oracle as a sources?
What's the Main Function of the Staging area in DWH
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?