Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for snowflake schema ?
- 2 Answers
- 8520 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 |
we have to use order by,where,having we to implement sql query
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
If we are using an aggregator but forget to mention the group by port .what will be the output??
wf dont have integration severances how you can run?
How do you load only null records into target? Explain through mapping flow.
What is query panel?
What are some examples of informatica etl programs?
What is primary and backup node?
How to enter same record twice in the target table,explain?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
Teradata 
