Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9285 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
Explain the etl program with few examples.
What is resilience time?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Differentiate between Load Manager and DTM?
How to extract sap data using informatica? What is abap? What are idocs?
Under what condition selecting sorted input in aggregator may fail the session?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the different kinds of facts.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain sessions and how many types of sessions are there?
Can we override a native sql query within informatica?
Tell me about MD5 functions in informatica
Scheduling properties,whats the default (sequential)
What are the different types of olap? Give an example?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
