what is a junk dimension ?

Answer Posted / srinu

junk dim is convient for group of flags and attributes to
get them out of a fact table inti useful dimension framework

Is This Answer Correct ?    15 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is exclusive and normal mode for repository services?

715


What is Session and Batches?

666


Which is the t/r that builts only single cache memory?

714


How to differentiate between the active and passive transformations?

628


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1697






Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

784


According to his methodology what all you need before you build a datawarehouse

1191


Is stop and abort are same in informatica?

573


Can we change Dynamic to Static or Persistent cache? If so what happens?

1730


What are the different lookup cache(s)?

621


What does update strategy mean, and what are the different option of it?

590


What is a passive transformation?

646


What are the measure objects?

664


What are the basic requirements to join two sources in a source qualifier transformation using default join?

616


How can we delete duplicate rows from flat files?

746