Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 87258 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / ande
two types of schemas r there: Star schema and snow flake
Schema: in Snow flake schema normalozation is promoted
where as in star schema denormalization is promoted. incase
of snowflake schema DB size will be saved but no of joins
will be increased and poor performance compare with star
schema
regards,
ande
| Is This Answer Correct ? | 71 Yes | 31 No |
Post New Answer View All Answers
What is a node in Informatica?
What are the components of workflow manager?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is a code page?
update strategy transformation in informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the difference between stop and abort in informatica
Enlist some properties of sessions.
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a rank transform?
What is target designer and target load order?
How an expression transformation differs from aggregator transformation?
Separate from a database, an information bazaar, and an information stockroom?
