how do u tune queries?
Answer / chitti
U CAN TUNE U R QUERIES BY CREATING INDEXES ON COLUMNS,AND
ELIMINATING KEY CONSTRAINTS .AND ALSO GIVE SORTING IN SQL
ITSELF.
| Is This Answer Correct ? | 2 Yes | 4 No |
what are challenges that you faced in testing? give solution to it?
What is the commit type if you have a transaction control transformation in the mapping?
How we can use union transformation?
Write the advantages of partitioning a session?
how to load dimension table and fact table. plz tell me the steps.
write a query for how to eliminate the duplicate rows without using distinct?
Explain the tuning lookup transformation - informatica
How do you take back up of repository?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
How can you validate all mappings in the repository simultaneously?
What is Java Transformation? what are the uses of it?
how can u avoid duplicate rows in flat file?