Answer / srinivas

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

By defying the number of readers per node option.

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

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.

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---

What is the difference between odbc and drs stage?

0 Answers  

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

Explain entity, attribute and relationship in datastage?

0 Answers  

---

What is active and passive stage?

0 Answers  

---

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

---

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

---

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---