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
How to do unit testing in informatica? How to load data in informatica ?
What is repository manager?
What is the sql query overwrite in source qualifier in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
where to store informatica rejected data?
How can we update a record in the target table without using update strategy?
What is parallel processing in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
what is mean by complex business rule ?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
whats the logic to load the lower level of granularity of data to fact table.
What is meant by target load plan?
How to use procedural logic inside infromatica?