what is hash table in informatica?
Answer / 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 |
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
Name the different lookup cache(s)?
What if the source is a flat-file?
What is Micro Strategy? Why is it used for?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
How to use Normalizer transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
how to run 2 workflows sequentially. plz respond what is the process?
What are the different threads in DTM process?
what are objects in data warehouse?