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?
Answer Posted / 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 |
Post New Answer View All Answers
What is quality stage?
Differentiate between data file and descriptor file?
explain about citrix scheduling tool in datastage
Explain datastage architecture?
What is active and passive stage?
Could anyone give brief explanation bout datastage admin
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
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?
In Datastage, how you can fix the truncated data error?
root tree will find which is server job and which is parallel job?
Can you explain engine tier in information server?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the difference between informatica and datastage?
Describe stream connector?
What is the difference between server job and parallel jobs?