Write the advantages of partitioning a session?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

tell me about your project functionality

0 Answers  


i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,


Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


How do you handle decimal places while importing a flatfile into informatica?

1 Answers  


Can anyone briefly describe abt audit table loading?

2 Answers   TCS,






What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,


When to use normalization transformation other than cobol source?

2 Answers  


in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


What is confirmed dimension?

3 Answers  


wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,


Categories