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
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Types of error logs in Informatica?
How you load distinct records into one target and duplicate records into another target?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is difference between partioning of relatonal target and partitioning of file targets?
Why use the lookup transformation ?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the prerequisite tasks to achieve the session partition?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is a design?
Mapplets can you use an active transformation in a mapplet,