Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9304 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
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How would you copy the content of one repository to another repository?
Where are the source flat files kept before running the session?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Which is the t/r that builts only single cache memory?
what is the Default Source Option For Update Strategy Transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are roles and groups and benefits of using them?
How can we delete duplicate rows from flat files?
What is status code in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the different options available for update strategy?
In warehouses how many schemas are there?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the different lookup cache(s)?
