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 |
What are the performance considerations when working with aggregator transformation?
Discuss the advantages & Disadvantages of star & snowflake schema?
I want load the data into target with out 1st and last record.
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
is it possible to index the data in cache of lkp transformation ?
how to we create datamart?
how we load the data from source to staging area
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
What are the new features of informatica 9.x developer?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records