my source is sequencial file and my target is dataset.
i am running the job in two node configuration file.
my source having 10 records how the data move to target?
Answers were Sorted based on User's Feedback
Answer / bala
Depends on your partitioning method. If its auto - entire
rows will pass in single node.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / kavi
If we use Round Robin partitioning method,5 rows in one
node & another 5 rows in 2nd node.
If it is Entire partitioning method,all the 10 rows go into
both the nodes.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / ankit gosain
Hi All,
Well it depends upon the partitioning technique used at the
target.
Note: Since source is a Sequential file which is sequential
operator, it will run on a single node, no matter how many
node the configuration file is & all the 10 records will go
sequentially. But Dataset is used as a target which is a
parallel operator, it will run parallely on all the nodes
defined & the data will be distributed according to the
partitioning technique used at the target ( if the records
are not duplicate on the basis of key then we can say that
the data distribution amongs the nodes will be even).
Cheers,
Ankit :)
| Is This Answer Correct ? | 2 Yes | 1 No |
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
How to implement complex jobs in data stage?
what about data stage requirement
explain unit testing,systemtesting,integrated testing
what are the different type of errors in datastage?
whats relation between configuration file and datasets?
DataStage Scenario based Interview Questions
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
what is the difference between == and eq in UNIX shell scripting?
Give example for FACTLESS FACT TABLE in real-time scenario.
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
whats difference between ls -ltr and ls -lrt?