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 Datastage 7.5 and 7.0?

0 Answers  


what is main difference between change capture and change apply stages

4 Answers   IBM,


How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,


How can you write parallel routines in datastage PX?

0 Answers  


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.

4 Answers   Wipro,






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?

0 Answers  


source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,


Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,


What is datastage engine?

0 Answers  


What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  


How to RD using transformer?

0 Answers   CTS,


What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,


Categories