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 |
How to enter a log in auditing table whenever a job get finished?
What is the importance of the exception activity in datastage?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
what is data mapping
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
I have a few records all are same structures data, I want to store data in multiple targets how?
how to change left and right links in join stage?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
What steps should be taken to improve Datastage jobs?
what is the diff between sequential file and fileset stages?