Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9424 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / venky
write post sql in target table as truncate table tablename
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the main issues while working with flat files as source and as targets ?
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.
What is depict expression change?
While migrating the data from one environment to another environment how would you manage the connections?
What are the types of caches in lookup? Explain them.
To import the flat file definition into the designer where should the flat file be placed?
What is informatica?
What is an expression transformation?
Define sessions in informatica etl?
Under what condition selecting sorted input in aggregator may fail the session?
What does cheating measurement mean?
What is a surrogate key?
How can we handle two sessions in informatica?
How to do unit testing in informatica?
How to load the data from people soft hrm to people soft erm using informatica?
