Explain why we use partitioning the session in informatica?
No Answer is Posted For this Question
Be the First to Post Answer
How many numbers of sessions can one group in batches?
How to send duplicates to one target and unique rows to one target?target is empty
How many joins in Informatica
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
Can I create one wrkflw which will run different wrkflws on schedule time?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
What is xml source qualifier transformation in informatica?
can we import source table without using source qualifier? if yes then how? if no then why?
What are the tuning techniques you applied during your last project
explain abt union t/r?