How to delete the data in the target table after loaded.
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 |
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
can we have to do changes in session property when we are dynamically generating target files?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
how can one eliminate dupliacte data with out using distinct option?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
what is the logic will you implement to load data into a fact table from n dimension tables?
Is there any way to read the ms excel datas directly into informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
Plz can any one say me how to get the informatica certification materials and dumps