Interested to Buy Any Domain ? << Click Here >> for more details...
1.what is activity count?
2.what is skew factor?
how it's working explain brefily
- 5 Answers
- 32883 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / tdguy
activity count - rows processed by sql.
skew factor - distribution of data over the amps.
when the distribution is highly skewed, the amp working may
be affected, which inturn affects parallelism.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of joins in teradata and what are the available join types?
What type of indexing mechanism do we need to use for a typical data warehouse?
List out teradata data types?
Explain teradata vs. Redshift?
What are different table types used in teradata?
What are the available join types in teradata?
How will you solve the problem that occurs during update?
What are the joins in teradata and how many types of joins are there in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
Why managing the data is important?
Explain and compare pros and cons of start schemas?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What are normalization, first normal form, second normal form and third normal form?
What is a sparse index?
how can we analyze the locks ?
