Answer / varma

Using filter or Transformer

Answer / prasad

If the source is Oracle,or any Rdbms then use the 'where
clause' option in the 'available properties to add' tab
other wise we can done using 'filter or transformer'

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,

---

what is advantages of snowflake when it is used?

3 Answers   IBM,

---

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

2 Answers   Satyam,

---

What is the difference between the local container and shared container?

0 Answers  

---

Can you explain repository tables in datastage?

0 Answers  

---

What is the difference between passive stage and active stage?

0 Answers  

---

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

How to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---