Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?

Question Posted / laxman

Answers were Sorted based on User's Feedback



What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

Answer / prabhu

Junk dimension contains the data which are currently not
useful. we have to keep these data for feature analysis
purpose.
Whereas Confirm dimentions are common for multiple fact
table.

Is This Answer Correct ?    4 Yes 0 No

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

Answer / sarvesh

merge two or more dimensional tables which are having the
low cardinality colomns into a single table is known
as "junk dimensional tables,
two or more fcat tables can be shared with a single
dimensional table is known as "conformed dimension"

Is This Answer Correct ?    2 Yes 2 No

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informat..

Answer / chaitanya

An interesting use for a junk dimension is to capture the context of a specific transaction. While our
common, conformed dimensions contain the key dimensional attributes of interest, there are likely
attributes about the transaction that are not known until the transaction is processed.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

design of staging area?

0 Answers  

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

What is joiner transformation in informatica?

0 Answers  

What are active and passive transformations?

0 Answers   Informatica,

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

What is the function of union transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories