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
Loading Fact table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
Re: Loading Fact table
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 )
better luck for your DS training ( if not planning then plan it )
Thanks
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
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.source-- SQ ---lookup1 on dim1
SQ----lkp2 on dim2
SQ----lkp3 on dim3 -------- Expression ----- target
SQ-----lkp4 on dim4
All the ETL will follwo the same logic.