Is snow flake or star schema used?
If star schema means why?
Answer Posted / koti
star schema is for simple data marts where as snowflake
schema for complexives...
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the need of an ETL tool?
how to load dimension table and fact table. plz tell me the steps.
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
COM components can be used in Informatica
what are the Methods For Creating Reusable Transformations?
What is persistent lookup cache?
what is the -ve test case in your project.
What the difference is between a database, a data warehouse and a data mart?
How we can create indexes after completing the load process?
How do you handle two sessions in Informatica
What is an expression transformation in informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Informatica settings are available in which file?
Partition, what happens if the specified key range is shorter and longer