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
What is lookup transformation?
What are the restrictions of union transformation?
Design time, run time. If you don't create parameter what will happen
write a query to retrieve the latest records from the table sorted by version(scd)
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Differentiate between reusable transformation and mapplet.
Difference between Data and Index Caches?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is meant by target load plan?
Explain the scenario which compels informatica server to reject files?
What is the use of target designer?
can u any challenge your project?
What are the types of presistent cache in look up tr.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.