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



I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which..

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

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which..

Answer / vijay

Ankit bhai you r genius.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is the difference between validate and compile?

1 Answers   CTS,


how to closeing records after 10,000 records come?

3 Answers  


What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,


what is the definitions for Datawarehose and Datamart?

4 Answers  


What are some prerequisites for datastage?

0 Answers  






How to perform incremental load in datastage?

0 Answers  


I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  


what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,


How to remove blank spaces from data?

3 Answers  


What are constraints and derivations?

0 Answers  


how can we join one oracle & flat files ?

2 Answers   ME,


how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,


Categories