Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the difference between truncate and delete in which
situation u use delete and truncate in real time..
- 4 Answers
- 13910 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / siva
In addition to Mukesh's answer, the truncate and delele
commands can also used on partitions in Oracle to truncate
or delete the records from the particular partition..
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How can you validate all mappings in the repository simultaneously?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the format of informatica objects in a repository?
How to go to the older version for a mapping?
Clarify the aggregator change?
Separate from a database, an information bazaar, and an information stockroom?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Can u generate reports in Informatica?
What are data-driven sessions?
How can we create index after completion of load process?
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.
How to load last n records of file into target table - informatica
Differentiate between router and filter transformation?
How do you set a varible in incremental aggregation
