Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance
issue. how to fix the performnce issue of the query.
No Answer is Posted For this Question
Be the First to Post Answer
What is a sorter transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is primary and backup node?
what is the difference between Informatica7.1 & informatica 8.1
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
What is a shortcut and copy in Informatica and how two are different with each other?
Explain the pipeline partition with real time example?
what is datamart
what is the size of u r source(like file or table)?
what are the Methods For Creating Reusable Transformations?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?