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 is the gap analysis?
How do you join more than 3 flat files in informatica?
How to view and Generate Metadata Reports?
what are the different types of transformation available in informatica and what are the mostly used ?
What is workflow manager?
Can you generate sequence numbers without using the sequence generator transformation?
Explain how many types of dimensions are available in informatica?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
Separate from a database, an information bazaar, and an information stockroom?
what is data driven?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are two types of processes that informatica runs the session?