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

How three column in one table concatenated in Informatica?When i am giving SAL || COMM || DEPTNO in exp it's failed to read during testing.By giving (CONCAT(CONCAT(SAL,COMM),DEPTNO)) i am also getting error during testing.

ramakrishna82

 Profile Answers by ramakrishna82 Questions by ramakrishna82

• Aug 12th, 2009

emp_first_name |' '|emp_middle_name|' '|emp_last_name

raj_infadev

 Profile Answers by raj_infadev Questions by raj_infadev

• Oct 13th, 2008

In Informatica its better to use the symbols to make the operation faster cause Power Center Server can understand the symbols more easily than the function names....For Example: Concatenation operati...

Answer Question  Select Best Answer

What is the difference between SQL Override and Lookup Override

VENKATM

• Jan 2nd, 2016

You cannot use directly Union in Lookup Override. You can use in SQL Override. No join conditions in SQL Override. Join condition is compulsory in lookup.

dbseeker

 Profile Answers by dbseeker Questions by dbseeker

• Dec 20th, 2015

Can we have a different opinion on the 4th point? "Lookup override gives only one record even though there..." A lookup can return more than one record. We could handle this using the lookup property ...

Answer Question  Select Best Answer

What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.

Manjunath

• Apr 9th, 2015

both Dim Modeling and ER modeling can be 3NF, which is highly normalized, As raj mentioned ER is used for OLTP and DM for OLAP. in both the cases data is stored in a set of tables and related to each ...

Sharat

• Jan 5th, 2015

Raj, 1NF is highly denormalized and the higher forms are more normalized. You said Dimensional Modeling is for datawarehouses and uses 3NF. Contains denormalized data. 3NF is highly normalized and how can the datawarehouses can have denormalized data

Answer Question  Select Best Answer

What are the advantages and disadvantages (if any) of upgrading the mappings from Informatica 7.1.3 to Informatica 8

raj_infadev

 Profile Answers by raj_infadev Questions by raj_infadev

• Oct 13th, 2008

hi thereits not the matter of advantages or disadvantages for upgrading. its all depends on client requirement. if the client feel that using higer version is more comfortable and ease of use and...

Answer Question  Select Best Answer