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...


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

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

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,


Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,


In target table how to display the system time

1 Answers  


what is index?how it can work in informatica

0 Answers  


in which situations do u go for scds ?

3 Answers   TCS,


What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  


what is dimension table?

17 Answers  


What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,


where is the reject loader .

1 Answers  


How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  


hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,


Categories