What is hash table informatica? - In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key.Use hash partitioning when you want the Informatica Server to distribute rows to the partitions by group. For example, you need to sort items by item ID, but you do not know how many items have a particular ID number. - Informatica Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

INFORMATICA

DETAILS

Question: What is hash table informatica?

Answer: In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key.Use hash partitioning when you want the Informatica Server to distribute rows to the partitions by group. For example, you need to sort items by item ID, but you do not know how many items have a particular ID number.

Category	Informatica Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7409 users
Added on	7/26/2011
Views	72407
Rate it!

Question: What is hash table informatica?

Answer:

In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key.Use hash partitioning when you want the Informatica Server to distribute rows to the partitions by group. For example, you need to sort items by item ID, but you do not know how many items have a particular ID number.

Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is meant by EDW?	View Answer
	How to load the data from people soft hrm to people soft erm using informatica?	View Answer
	What are the measure objects	View Answer
	How can we join the tables if the tables have no primary and forien key relation and no matchig port to join?	View Answer
	If the workflow has 5 session and running sequentially and 3rd session hasbeen failed how can we run again from only 3rd to 5th session?	View Answer
	What is the diff b/w STOP & ABORT in INFORMATICA sess level ?	View Answer
	What is the diff b/w Stored Proc (DB level) & Stored proc trans (INFORMATICA level) ? again why should we use SP trans ?	View Answer
	What is surrogatekey ? In ur project in which situation u has used ? explain with example ?	View Answer
	In my source table 1000 rec's r there.I want to load 501 rec to 1000 rec into my Target table ? how can u do this ?	View Answer
	What is Partitioning ? where we can use Partition? wht is advantages?Is it nessisary?	View Answer
	How can we eliminate duplicate rows from flat file?	View Answer
	How to Generate the Metadata Reports in Informatica?	View Answer
	In certain mapping there are four targets tg1,tg2,tg3 and tg4. tg1 has a primary key,tg2 foreign key referencing the tg1's primary key,tg3 has primary key that tg2 and tg4 refers as foreign key,tg2 has foreign key referencing primary key of tg4 ,the order in which the informatica will load the target? 2]How can I detect aggregate tranformation causing low performance?	View Answer
	What are the different types of transformation available in informatica. and what are the mostly used ones among them	View Answer
	I have a situation here to load the Table into informatica. I have 5 temporary tables as sources. They look like: Table1: (K - Key, N-Null, X,Y,Z - values) K1 X N N N N K2 X N N N N -------------------------- Table2: K1 N X N N N K2 N X N N N -------------------------- the other 3 tables are in the same way. But there can be a situation like any of the table can contain duplicates like: K1 X N N N N K1 Y N N N N -------------------------- This kind of records should be errored out. Because of this, we can't use aggregator/group by as we are not sure which one should be removed. How can we obtain this functionality in Informatica.	View Answer
	What is a view? How it is related to data independence?And what are the different types of views,and what is Materialize view	View Answer
	Can u tell me how to go for SCD's and its types.Where do we use them mostly	View Answer
	When do u we use dynamic cache and when do we use static cache in an connected and unconnected lookup transformation	View Answer
	Can any one tell me how to run scd1 bec it create two target tables in mapping window and there are only one table in warehouse designer(means target).. so if we create one new table in target it gives error..	View Answer
	How to export mappings to the production environment?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Informatica Interview Questions & Answers - Exam Mode / Learning Mode