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
Define stored procedure?
What is the concept of Virtual field?
Display the employees whose salary is less than average salary.
Why merge statement is used inside the database?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
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
Explain storage manager?
How heap is implemented in database?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
How do you connect to a database?
If the master device is full, how do I make the master database bigger?
What is the function of cluster index?
What is ase database?
What are the advantages of using database?
