How to delete the data in the target table after loaded.
- 3 Answers
- 8106 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 |
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
What is the filename which you need to configure in UNIX while installing infromatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the different tools in workflow manager?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
What is facttable granularity?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What is an aggregator transformation?
how can u tune u r informatica mapppings
Explain dynamic target flat file name generation in informatica
According to his methodology what all you need before you build a datawarehouse
Teradata 
