How to delete the data in the target table after loaded.
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 what transformation and how many are there in informatica?
Explain informatica architecture - version 8 / 9
Slowly changing dimensions, types and where will you use them
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
whats the logic to load the lower level of granularity of data to fact table.
What are the differences between oltp and olap?
How do you load only null records into target? Explain through mapping flow.
What is mapplet in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Is there any way to read the ms excel datas directly into informatica?
What is target load order?
What is fact table? Explain the different kinds of facts.
Explain scd type 3 through mapping.
Please let me know how to make encryption and decryption with example?
What is meant by lookup transformation?