DSXchange

how to load data from target tables to dimension tables and

our source is some flat files and DB2 , target is informix. here how to load data from informix to Dimensional tables & fact tables .is it possible to load directly or any stages are required to load data into dimensions.

What is your requirement? you need to load the dimension and then the facts .Is your dimensions are from multiple target table of Informix? pls give us more detail on the DWH design.

Nothing magical about dimensions or facts, bottom line they're just tables like any other table, so you "load" them like any other table. Only thing about them is their "relationship" and the RI you may or may not have between them, so they need to be processed in the proper order just like any other parent/child master/detail tables.

Surely you've read from and written to flat files and tables in a DataStage job before? Only out-of-the-ordinary stage you might need to use would be the SCD or Slowly Changing Dimension stage but it's certainly not required even if you need to support Type 2 (etc) dimensions. Do you?