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.

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

---

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,

---

how can we do null handling in sequential files

2 Answers   Reliance,

---

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

What are stage variables and constants?

0 Answers  

---

Define meta stage?

0 Answers  

---

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 Answers  

---

what is hash file

2 Answers   CTS, IBM,

---