Answer / rajesh

Hi This is Rajesh. use copy stage for multiple copies.From that take 2 links to funnel n load to target ...u wil get 10

Answer / sravanthirao64@gmail.com

target can create instance

Answer / srikanth

it's not a big issue create a one more node extra and select
the partition entire and run the job


thanks & regards
sriaknth.k
9573056597

Answer / subbuchamala

Different ways are:

1. SRC-->COPY-->(2links)-->FUNNEL-->TGT
from copy stage get 2 copies of output data and send to funnel.

2. SRC-->Transfermer-->(2links)-->FUNNEL-->TGT
in the TFM, map the all the columns to both the links and then funnel them.

3. SRC--->TGT(with append mode)
Run job 2 times with TGT Seq file mode as "Append"

4. 2 SRCs(2 same Seq file Stages)-->Funnel-->TGT
read the same file from 2 Seqfile Stages and send them to funnel.

5. SRC--->TGT
Add 2 "File" properties in the Seq file stage and for both of them give the same file name and path.

File=directory/file.txt
File=directory/file.txt

What is the different type of jobs in datastage?

0 Answers  

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

How many types of sorting methods are available in datastage?

0 Answers  

---

How do you design PX Routines ?

1 Answers  

---

what are the types of nodes

4 Answers   HCL, TCS,

---

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

What are the benefits of datastage?

0 Answers  

---