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 is the exact difference between dataset and fileset in datastage?
in oracle target stage when we use load option and when we use upsert option?
What are the main features of datastage?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
How do you import and export the 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.
Explain connectivity between datastage with datasources?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
source file contains 100 records, i want 10 records in target file how it possible in datastage
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?