Answer Posted / subhash

I hope this will help you:

--------->T1
|
|
source---->transformer---------- -------->T2
|
|
--------->T3
Transformer:
1.drag source column to all the targets.
2.TARGET T1 constraint in Transformer:
Mod(input column, 9)=1 or Mod(input column, 9)=2 or Mod
(input column, 9)=3.
3.TARGET T2 constraint in Transformer:
Mod(input column, 9)=4 or Mod(input column, 9)=5 or Mod
(input column, 9)=6.
4.TARGET T3 constraint in Transformer:
Mod(input column, 9)=7 or Mod(input column, 9)=8 or Mod
(input column, 9)=0.

What are the types of hashed files in data stage

1146

---

which r the connectors used in san?

2229

---

Is it possible to query a hash file?

2060

---

What are the areas of application?

1197

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4238

---

How to Remove Duplicate using SQL?

1424

---

State the difference between an operational datastage and a data warehouse?

1183

---

What is the process of killing a job in datastage?

1067

---

What is the difference between datastage and informatica?

1185

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3182

---

How a server job can be converted to a parallel job?

1142

---

What is the differentiate between data file and descriptor file?

1412

---

Define Data Stage?

1143

---

What is "fatal error/rdbms code 3996" error?

1343

---