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

Highlight the main features of datastage?

0 Answers  


On which Dimension Table you implemented SCD Type in your Project

0 Answers  


I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,


What are operators in datastage?

1 Answers  


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  


Describe the architecture of datastage?

0 Answers  


Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,


I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,


How to read the length of word in unix?

0 Answers   CTS,


CHANGE CAPTURE

0 Answers   CTS,


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   TCS,


How can you join flat file, oracle as a sources?

4 Answers   IBM,


Categories