Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 9652 Views
- TCS, I also Faced
- E-Mail Answers
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 |
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
Can you explain tagbatch restructure operator?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
If you want to use a same piece of code in different jobs, how will you achieve this?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
what is the function in Transformer stage can act as Rank function in Oracle
Explain usage analysis in datastage?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
is it possible to access the same job by two users at a time in DataStage?
How do you generate sequence number in datastage?
How and where you used hash file?
Teradata 
