Page 1 of 1
Loading Fact table
Posted: Fri Apr 11, 2008 6:00 am
by 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
Posted: Fri Apr 11, 2008 6:15 am
by 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.
Posted: Fri Apr 11, 2008 6:38 am
by 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.
Re: Loading Fact table
Posted: Fri Apr 11, 2008 6:43 am
by 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 )
Posted: Mon Apr 14, 2008 3:02 am
by 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.