Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Define update strategy?
Explain what are the different types of transformation available in informatica.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Explain the features of connected and unconnected lookup.
Why do we need informatica?
How to implement security measures using repository manager?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the components of Informatica? And what is the purpose of each?
When do you use sql override in a lookup transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
In which transformation you cannot drag ports into it?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
State the limitations where we cannot use joiner in the mapping pipeline?
is it possible to index the data in cache of lkp transformation ?
