Answer Posted / pooja
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain pushdown optimization and types in informatica
Mention few advantages of router transformation over filter transformation.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What all join we can perform in LOOKUP transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is Data Caches size?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a stored procedure transformation?
How many ways a relational source definition can be updated and what are they?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is a joiner transformation and why it is an active one?
What is a filter transformation?
Explain sessions. Explain how batches are used to combine executions?