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


Please Help Members By Posting Answers For Below Questions

What is quality stage?

563


Differentiate between data file and descriptor file?

611


explain about citrix scheduling tool in datastage

1807


Explain datastage architecture?

808


What is active and passive stage?

872






Could anyone give brief explanation bout datastage admin

1963


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2174


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?

589


In Datastage, how you can fix the truncated data error?

636


root tree will find which is server job and which is parallel job?

1443


Can you explain engine tier in information server?

645


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3255


What is the difference between informatica and datastage?

650


Describe stream connector?

820


What is the difference between server job and parallel jobs?

659