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

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

1 Answers   Reliance,


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  


How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,


CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,


IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  






Explain the functionality of your current project?

1 Answers   IBM, Miles Software,


How to reverse the string using SQL?

0 Answers   CTS,


i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,


Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,


How many number of reject links merge stage can have?

7 Answers   TCS,


What's the Main Function of the Staging area in DWH

3 Answers   Oracle,


How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  


Categories