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

Explain the importance of surrogate key in data warehousing?

719

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2999

---

How we can covert server job to a parallel job?

601

---

Why fact table is in normal form?

683

---

What can we do with datastage director?

679

---

---

Have you have ever worked in unix environment and why it is useful in datastage?

657

---

Explain connectivity between datastage with datasources?

605

---

What is meta stage?

581

---

What is the purpose of pivot stage?

614

---

How the ipc stage work?

680

---

What are the important features of datastage?

623

---

What is the use of datastage director?

595

---

Why do we use link partitioner and link collector in datastage?

689

---

What are the difference types of stages?

627

---

How to convert RGB Value to Hexadecimal values in datastage?

3462

---