Comment on significance of oracle 9i in informatica when
compared to oracle 8 or 8i?
What is joiner cache?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
What are the active and passive transforamtions?
What are variable ports and list two situations when they can be used?
How to update or delete the rows in a target, which do not have key fields?
difference between source based commit? and target based commit? which is better with respect to performance?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
Tell me one complex query in oracle ?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?