Answer Posted / subhash

1. SRC---->TFM---->TGT1,TGT2,TGT#
If source is seq file add the ROW NUM column also.
If source is Oracle select ROWNUM column also.
then our input look like this:
C1 1
C2 2
C3 3
c4 4
c5 5
c6 6
c7 7

in TFM,
put below condition for each target link.
TGT1--->MOD(ROWNUM,3)=1
TGT2--->MOD(ROWNUM,3)=2
TGT3--->MOD(ROWNUM,3)=0

What is a ds designer?

1024

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1095

---

What are the different layers in the information server architecture?

1078

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2750

---

explain about citrix scheduling tool in datastage

2381

---

Demonstrate experience in maintaining quality process standards?

2458

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2045

---

What are the different options associated with dsjob command?

1372

---

Differentiate between validated and Compiled in the Datastage?

1196

---

Why do we use exception activity in Datastage?

1230

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2006

---

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?

2133

---

Define Job control?

1061

---

What is aggtorec restructure operator?

1344

---

Explain entity, attribute and relationship in datastage?

1045

---