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.
- 0 Answers
- 2918 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is data movement mode in Informatica and difference between them?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
How do you remove duplicate records in informatica?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is joiner change?
i have two source data there is no pk,fk how to join the two sources
what are the row and column separations in Flat Files
State the differences between sql override and lookup override?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
What is predefined event?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
Teradata 
