wt is the difference between truncate and delete in which
situation u use delete and truncate in real time..
Answer Posted / bose3508
After completion of history extraction from database you
may go for truncate.To cleanse the oltp database.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
What is lookup change?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Write the advantages of partitioning a session?
What is repository manager?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What happens when a session fails and you click on recover?
How do you handle two sessions in Informatica
What is substr in informatica?
permutations of mapplet
How can we improve session performance in aggregator transformation?
What is decode in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to partition the Session?
What are the types of schemas we have in data warehouse and what are the difference between them?