What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica.

Amar

• Nov 30th, 2012

The main logical difference is that we use connected lookup while loading dimensions and unconnected look up while loading facts

ASHU

• Jan 21st, 2012

A Dimension table contain descriptive (detailed) data and a fact table contain measurements (facts) which are used to evaluate a business, all numeric are not a facts but the numeric which are key performance indicators is known as facts.. fact table contain summarized data....

ASHU (KARIMNAGAR)

Answer Question  Select Best Answer

nandu214

 Profile Answers by nandu214 Questions by nandu214

• Jun 17th, 2008

Yes same as store procedure and one advantage of packages is it has overriding facility for this first we create package and store it in database before running the mapping

Kadhirvelu

 Profile Answers by Kadhirvelu Questions by Kadhirvelu

• May 12th, 2008

Hi,what kind of packages ? are you talking about Oracle PL/SQL packages, the answer is yes. In fact, you can use Stored Procedures, Stored functions. And in the same way, you can use Packages.

Answer Question  Select Best Answer