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
What is the need of an ETL tool?
How many types of sessions are there in informatica.please explain them?
Differentiate between sessions and batches?
Explain why we use partitioning the session in informatica?
What is a difference between complete, stop and abort?
What are the different versions of informatica?
What are the types of lookup transformation?
What is workflow? What are the components of workflow manager?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the designer tools for creating transformations?
Under what condition selecting sorted input in aggregator may fail the session?
What are the tuning techniques you applied during your last project
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Can we override a native sql query within informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you