What is hash partition?
Answers were Sorted based on User's Feedback
Answer / sudhanshu
Hash Partitioning, which maps data to partitions based on a
hash function. The physical location of the data depends on
the outcome of hash function. Data used to distributed
between the partitions. This is typically used where ranges
are not appropriate
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / murali s
The value of a hash function determines membership in a
partition. Assuming there are four partitions, the hash
function could return a value from 0 to 3.
Is This Answer Correct ? | 1 Yes | 0 No |
can we use cartesian join in informatica
what is the difference between stop and abort
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
How identifying bottlenecks in various components of informatica and resolving them?
What is the difference Between Mapping parameter and variable
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
How to enter same record twice in the target table,explain?
What is a command that used to run a batch?
What is a repository? And how to add it in an informatica client?
What is the way to execute pl/sql script using informatica mapping?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
How will you update the first four rows and insert next four rows in a mapping?