Interested to Buy Any Domain ? << Click Here >> for more details...
what is a nodemap constraint
- 2 Answers
- 13473 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pooja
Nodemap constraint is a property check in the stage. The
paralell execution of the job can be restriced to a
particular node or nodes at a stage level with this check.
It provides a drop down list of nodes available and by
selecting a particular node or nodes the job executes only
on that particular node or nodes.
For example, if the incoming data is being processed in
parallel mode on 4 nodes then in the next stage if the
nodemap constraint is checked and only 1 node is selected
then the entire data is processed in a sequential mode i.e.
on that particular node.
In case the incoming data processes on 4 nodes and nodemap
contraint is checked and 2 nodes are selected then the data
is distributed on these 2 nodes and the job process is
carried out on the same.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pooja
Nodemap constraint is a property check in the stage. The
job process can restriced at a stage level with this check.
It provides a drop down list of nodes available and by
selecting a particular node the process only on that
particular node.
For example, if the incoming data is being processed in
parallel mode then in the next stage if the nodemap
constraint is checked then from here on the processing
takes place in a sequential mode.
| Is This Answer Correct ? | 4 Yes | 3 No |
which dim, fact tables used in bank domain
Define Merge?
what is the exact difference between dataset and fileset in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
How do you remove duplicate values in datastage?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
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.
What are data elements?
What is a ds designer?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
Teradata 
