Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amish ojha
applying hashing algorithm to the PI system gets the ROW
HASH ,that will be searched in the HASH BUCKET to get the
desired AMP ,thereafter by adding uniqueness value to row
hash value the row ID is obtained and then it gets stored
in AMP ..
PI-->ROW HASH ---> HASH BUCKET(MAP)--> AMPno
ROWID = ROW HASH + UNIQUENESS ID
where actually the row is stored
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is transaction state, buffer management, shadow paging
Display the employees whose salary is less than average salary.
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What is ole db provider for sql server?
What are different types of resources?
Under which circumstance should you create an index on a table?
What is a reference table in database?
How do database connections work?
What is the concept of Virtual field?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
how do you do sql tuning?
Give the syntax of exception handling used in DBMS?
Explain alternate key?
Explain transaction manager?
