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



my source is sequencial file and my target is dataset. i am running the job in two node configurati..

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

my source is sequencial file and my target is dataset. i am running the job in two node configurati..

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

my source is sequencial file and my target is dataset. i am running the job in two node configurati..

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

Post New Answer

More Data Stage Interview Questions

What is the difference between passive stage and active stage?

0 Answers  


1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  


how CAN we remove duplicates in dataset?

2 Answers   IBM,


what is datastage job Monitoring

6 Answers   CTS,


CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  


whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  


how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,


what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,


In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,


How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,


Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,


Categories