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 are transforms and what is the differenece between routines and transforms?
what is use of SDR function?
Define orabulk and bcp stages?
What are the benefits of datastage?
What is a quality stage in datastage tool?
How many types of hash files are there?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the different plug-ins stages used in your projects?
Differentiate between hash file and sequential file?
What are the different kinds of views available in a datastage director?
how to export or import the jobs in .ISX file
What are routines in datastage?
Differentiate between operational datastage (ods) and data warehouse?
Triggers,VIEW,Procedures
How to find value from a column in a dataset?