starsaran007

 Profile Answers by starsaran007 

• Sep 30th, 2006

 

hi

The differerence between reference link and straight link is

The straight link is the one where data are passed to next stage directly and the reference link is the one where it shows that it has a reference(reference key) to the main table

for example in oracle EMP table has reference with DEPT table.

In DATASTAGE

2 table stage as source (one is straight link and other is reference link) to 1 transformer stage as process.

If 2 source as file stage(one is straight link and other is reference link to Hash file as reference) and  1 transformer stage. 

i think you got it

regards

saravanan