How to delete the data in the target table after loaded.
Answer Posted / honey
SQ---> Properties tab-->Post SQL
delete from target_tablename
SQL statments(s) executed using the source database
connection, after a pipeline is run
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
In informatica workflow manager, how many repositories can be created?
difference between informatica 8.1.1 and 8.6
explan ur project architecture?
Make a note of the quantity vaults made in informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
Mention few power centre client applications with their basic purpose?
What is meant by LDAP users?
Explain the different dimensions.
What is the procedure for creating independent data marts from informatica 7.1?
Enlist the various types of transformations.
How many number of sessions can one group in batches?
Whats there in global repository
difference between repository database and repository service?
Can we create a node as a gateway node and the same node can be assigned to a grid?