What is the default execution order of the sequential file?

Answers were Sorted based on User's Feedback



What is the default execution order of the sequential file?..

Answer / srinivas

By default it is sequential but we can make it as parallel.

By defying the number of readers per node option.

Is This Answer Correct ?    6 Yes 0 No

What is the default execution order of the sequential file?..

Answer / dipanjan17

The execution mode of Sequential file stage in datastage is
sequential by default.You can validate that from :

Sequential file stage--->Stage tab-->advanced tab ---
>Execution Mode

Is This Answer Correct ?    6 Yes 1 No

What is the default execution order of the sequential file?..

Answer / shar

It behaves different w r t reading capability.
i.e.,
when it is reading a single file; it does sequential mode of
reading by default and when it is reading multiple files it
does parallel mode of reading by default.

And if we need to improve performance of sequential file
stage when reading a single large file then we have two
options:
1. Read from Multiple Nodes
2. No of readers per node.

1st one is applicable only when flat file is Fixed length
file and not applicable for delimited formatted files.

The latter one is applicable for delimited files by
mentioning no of nodes then it performs parallel mode of
execution by reading single file in partitions improving the
performance.

Thats it.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What are the different types of lookups in datastage?

0 Answers  


Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  


how can we do null handling in sequential files

2 Answers   Reliance,


source contains 2 columns comes to target 4 columns how

1 Answers   IBM,


What is the difference between operational data stage (ods) and data warehouse?

0 Answers  


SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  


HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,


Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,


can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,


Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,


What is a delta record? How you will read it?

0 Answers   EDS,


What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


Categories