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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain lookup transformation is active in informatica
How we can create indexes after completing the loan process?
Explain direct and indirect flat file loading (source file type) - informatica
What is persistent lookup cache?
can you please explain me pre session and post session options?
Mention some types of transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the function of union transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to update a particular record in target with out running whole workflow?
Why is sorter an active transformation?
What is dynamic cache?
can u any challenge your project?