Loading Fact table

[ketanshah123]

hi,
i already worked in informatica now i m working on datastage...

i know how to load fact in informatica.. it goes like this...

source-- SQ ---lookup1 on dim1
SQ----lkp2 on dim2
SQ----lkp3 on dim3 -------- Expression ----- target
SQ-----lkp4 on dim4

can anybody pls suggest me how it will look in datstage ???

thanks in advance

[WoMaWil]

If you know to drive a Porsche it might be relativly easy to drive a Ferrari next day.

Concerning DataStage:

FTFM and go to a training session, otherwise your jobs will not be first class.

[ray.wurlod]

Obviously it will "look" quite similar, since it is performing the same task.

Tip: when "drawing" in DSXchange, use Code tags, and use Preview to get it right.

Once you move to version 8 of DataStage, loading of the dimensions and the fact table can all be done in the one stream (if that's how you want to design it), using the new Slowly Changing Dimension stage.

[swapnilverma]

what are you talking here is concept ....it will be same in any ETL tool...

better luck for your DS training ( if not planning then plan it )

[bkumar103]

source-- SQ ---lookup1 on dim1
SQ----lkp2 on dim2
SQ----lkp3 on dim3 -------- Expression ----- target
SQ-----lkp4 on dim4

It will same in the data stage too. There is lookup satge available in DS also. or you can use the joiner stage also. Instead of expression stage use the transformaer in the Datastage.

All the ETL will follwo the same logic.