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 |
What are the tasks that source qualifier perform?
what is $$$$?
Differentiate between reusable transformation and mapplet.
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
What are the disadvantages of Sequence Generator T/R?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
In joiner, how to load Master table in Target?
How can we improve session performance in aggregator transformation?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
What are the components of the workflow manager?
How Union Transformation is an Active Trans?