What is hash partition?
Answer / bhanu pratap
Hash partitioning:-
use hash partitioning , when we want the power center server
to distribute rows to the partitions by groups.
Eg :- we need to sort items by item ID , but we don't know
how many many items have a particular ID mamber
Is This Answer Correct ? | 6 Yes | 1 No |
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
How to update records in Target, without using Update Strategy?
what is hash table in informatica?
how may sources can be used in a mapping at a time?(limit)
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain about HLD and LLD ?
Reusable transformation and shortcut differences
What is Index Caches size?
How to configure mapping in informatica?
What is IQD file?
How to load the data from people soft hrm to people soft erm using informatica?