Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9429 Views
- TCS, I also Faced
- E-Mail Answers
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
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain lookup transformation in informatica
Explain the mapping variable usage example in informatica
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the different types of transformation available in informatica.
in reporting we add some new objects,how we get the count of the newly added objects to the report
During the running session, output files are created by informatica server. Enlist few of them.
Explian the Process of deployment groups in informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is powercenter on grid?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How do you load only null records into target? Explain through mapping flow.
What are the new features of Power Center 5.0?
What is the session task and command task?
