Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9290 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venky
write post sql in target table as truncate table tablename
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
we have the property in session truncate option.
| Is This Answer Correct ? | 1 Yes | 10 No |
What is a repository manager?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
What are the new features of informatica 9.x in developer level?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
what is sql override?what is the use of it?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
To achieve the session partition what r the necessary tasks u have to do?
difference between repository database and repository service?
What are the advantages of informatica?
where is the reject loader .
Teradata 
