Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for snowflake schema ?
- 2 Answers
- 8390 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bala
If suppose we are having the multiple Fact tables and
multiple dimension tables normalized data ; we can go for
snowflake schema.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / giri
it will used at time u will maitain normalised data u r
data having more cordinality dat tables
| Is This Answer Correct ? | 0 Yes | 0 No |
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
Which version configuration tool used in ur project?
Target increases every day even though no new record was inserted
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
how to move the mappings from your local machine to claint place?
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.
What is update override?
what is workflow varible
How to prepared lld.can any one tell me detailed explanetion.
In which transformation you cannot drag ports into it?
what is the complex transformation you used in informatica
Teradata 
