Answer Posted / amit

read the file from sequential file stage, use a transformer in between, write the same data to the same file using sequential file stage as target by setting option to - load file in append mode.

What is the difference between odbc and drs stage?

637

---

What are the primary usages of datastage tool?

623

---

How many types of stage?

673

---

How to Remove Duplicate using SQL?

839

---

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?

1743

---

---

What are the areas of application?

656

---

How to manage date conversion in Datastage?

638

---

How do you import and export data into datastage?

695

---

What are the various kinds of containers available in datastage?

559

---

Define ds designer?

766

---

What is the difference between datastage and informatica?

609

---

What is the difference between server job and parallel jobs?

662

---

What are the difference types of stages?

619

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

963

---

Can you explain engine tier in information server?

649

---