how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy

Answer Posted / gm

You load dimension table before loading fact table. But
using Dynamic Lookup, you can load both simultaneously.
======

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is different between the data warehouse and data mart?

620


Can you generate sequence numbers without using the sequence generator transformation?

591


Which files are created during the session rums by informatics server?

697


How can we update a record in the target table without using update strategy?

644


What is joiner change?

662






How to use pmcmd utility command?

573


How to create or import flat file definition in to the warehouse designer?

601


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1518


What are the reusable transformations?

689


can we override a native sql query within informatica? Where do we do it?

617


I have a flat file, want to reverse the contents of the flat file

681


Explain pushdown optimization and types in informatica

656


can anyone suggest best free Talend data integration training online

1247


What is a rank transform?

664


hi real timers . iam waiting for ur reply regarding ETL TESTING

1793