Answer / subhash

Qns is not clear, as per my understandings:

connect 5 sources(if they have same metadata) to funnel
funnel to copy stage
copy stage to 5 diff targets
then u will get same data in 5 targets.

Answer / rathdsetl@gmail.com

For example
Source1
c1
source 2
c2
soucr 3
c3
source 4
c5
source 5
c5





my target belongs to


target1
c1
target 2
c2
target 3
c3
target 4
c5
target 5
c5


This is dump date

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

What is the difference between lookup and sparse lookup?

1 Answers  

---

on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,

---

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

---

What is a folder? Difference types of stages?

0 Answers  

---

---

What are the types of containers in datastage?

0 Answers  

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,

---

Main Function of the Staging area in DWH ?

2 Answers  

---

What are operators in datastage?

1 Answers  

---

What is data partitioning?

0 Answers  

---