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 are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How Union Transformation is an Active Trans?
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
what is informatica metadata?
Describe two levels in which update strategy transformation sets?
expain about the tune parameters?
why do we go for update strategy tr in SCD rather using the session properties?
have u done any performance tuning? how u ll do?
What are the different clients of powercenter?
What are the uses of a Parameter file?
what is the diff b/w target load plan and cbl?
what is the complex transformation you used in informatica