Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
have u done any performance tuning? how u ll do?
How do you handle two sessions in Informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Where is metadata stored?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How do you load only null records into target? Explain through mapping flow.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain informatica architecture - version 8 / 9
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is an aggregator transformation?
How can we remove the duplicates from flat file source?
What is Index Caches size?
How can we update a record in the target table without using update strategy?
