I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
Answers were Sorted based on User's Feedback
Answer / ankit gosain
Hi,
Job will run smoothly but the dataset will run on 2 node
configuration.
This is because whenever you create a dataset, 4 componets
are created which are Discriptor file, Data file, Header
File and Control file. Now, when that dataset was created
with 2 node configuration, it captured the configuration
file into it's Discriptor file and now if you'll use that
dataset in some other environment with 4 node
configuration, it won't affect anything, since the
discriptor have the configuration of nodes when it was
creadted.
You can cross check it by using the environment variable
APT_DUMP_SCORE.
If you have further doubts or query, you can mail me at
ankitgosain@gmail.com
Cheers,
Ankit
Is This Answer Correct ? | 6 Yes | 1 No |
What is the difference between Datastage 7.5 and 7.0?
what is main difference between change capture and change apply stages
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How can you write parallel routines in datastage PX?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
What is datastage engine?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
How to RD using transformer?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?