Answer Posted / amar deep reddy

Hi Vijay,

You can do it by setting the 'No. of readers per node'
property value to >1. When you do this there will be n No.
of readers created in the node and each reader will read a
block of data from the sequential file.

If you have multiple input files (pattern), you can set the
property 'Read from multiple nodes' to 'yes'.

These 2 properties of sequential files are mutually
exclusive.

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

2143

---

Explain datastage architecture?

1384

---

What are iconv and oconv?

1224

---

What is quality stage?

976

---

Define project in datastage?

1085

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2167

---

Describe the main features of datastage?

1066

---

How do you register plug-ins?

955

---

What are the different plug-ins stages used in your projects?

1062

---

Triggers,VIEW,Procedures

1214

---

How many types of sorting methods are available in datastage?

1061

---

I have a few records just I want to store data in to targets cycling way how?

2341

---

How will you move hashed file from one location to another location?

2142

---

What are routines in datastage?

1314

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

787

---