Answer Posted / vijay

Hi Kiran ,

We can populate the sources metadata to target without
using funnel stage using "Seqential File" Stage.

let me explain

In Sequential file we have a property called "File" so first
u give the file name and load the data.

Next time in the same sequential file right side we have a
property "File" just click on that so it will ask another
file name just give other file name ...do not load the data
, in the same you can give how many files u have.

Finally u ran the job Automatically the data will be appended.

Thks

What is the difference between odbc and drs stage?

1041

---

What are the steps needed to create a simple basic datastage job?

1155

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2756

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2205

---

How complex jobs are implemented in datstage to improve performance?

958

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2405

---

Define Data Stage?

1037

---

Explain Quality stage?

1085

---

What are the different common services in datastage?

1211

---

Distinguish between informatica & datastage. Which one would you choose and why?

952

---

How do you reject records in a transformer?

1055

---

How to Remove Duplicate using SQL?

1288

---

What are the functionalities of link partitioner?

971

---

What are routines in datastage? Enlist various types of routines.

1047

---

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

2002

---