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 informatica powercenter repository?
Could you explain what is enterprise data warehouse?
How can we update a record in the target table without using update strategy?
What is meant by pre and post session shell command?
pmscmd startworkflow -sv
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is domain in terms of informatica?
How to join three sources using joiner? Explain though mapping flow.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is size of u r database?
What are the tasks that source qualifier perform?
Briefly define reusable transformation?
How can one identify whether mapping is correct or not without connecting session?