Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updation of Fact table

Status
Not open for further replies.
nphani77

nphani77

Programmer
Jun 11, 2003
8
0
0
US
Hi,
How to Update a big fact table having 13 dimensions and Millions of rows using informatica with optimum Performance? One thing i was pondering upon is that is it a good practise to use a fact table as Lookup table?
Please answer this ASAP
 
Sort by date Sort by votes
If you can avoid using fact table as a lookup table it will give u better performance. It also always unadvisable to use fact table as a lookup.


-Ajay
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Router Output to a "Single Target Table"
Replies
1
Views
74
rasETL
rasETL
sa0309
  • Locked
  • Question
Informatica Target Table update 1
Replies
2
Views
69
sa0309
sa0309
mscheja
  • Locked
  • Question
InfoSphere Information Server: Configuring the location of the
Replies
0
Views
50
mscheja
mscheja
sweetleaf
  • Locked
  • Question
Standard for change mgt of data feeds
Replies
0
Views
39
sweetleaf
sweetleaf
rodneyc8063
  • Locked
  • Question
Informatica Query Tables for Workflow Schedules (SCHEDULER, WORKFLOWS)
Replies
1
Views
93
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top