what is skew and skew measurement?
- 2 Answers
- 17929 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ck
Skew measures the relative imbalance in Parllel loading.
Un-even Load balencing causes the Skew.
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / freak.abinitio
skew is the mesaureof data flow to each partation .skew is a indericet measure of graph.
The sKew of a data partition is the amount by which its size deviates from the average partition size expressed as a percentage of the largest partition:
PaARTION size - avg partition size
------------------------------------- X 100
size of larget partion
| Is This Answer Correct ? | 2 Yes | 1 No |
What is the purpose of having stored procedures in a database?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
what is the difference between i)public ii)private iii)common and client projects?
What is the difference between a scan component and a rollup component?
What are the functions of the replicate and dedup component?
How will u remove header record? How will u remove tailer record?
What is the difference between In-Memory Sort and Inputs must be sorted?
how to prepare scd2 in abinitio
Explain how you can run a graph infinitely in ab initio?
What is is a data flow graph?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
Explain the difference between the truncate and delete commands?
Teradata 
