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
What is the function of union transformation?
Parameter and variable differences
Define update strategy?
What is an Integration service in Informatica?
What is the Rank index port in Rank transformation?
What are the main features of Oracle 8i with context to datawarehouse?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the difference between informatica 7.0 and 8.0?
write a query to retrieve the latest records from the table sorted by version(scd)
What is dynamic cache?
Difference between Data and Index Caches?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Write the unconnected lookup syntax?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar