Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9119 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
what is mean by complex business rule ?
tell me about your project functionality
What is DR strategy for Informatica project?
Is it possible to use a client with different version than that of its Informatica server?
Under which circumstances, informatica server creates reject files?
Enlist some properties of sessions.
What is the different lookup cache(s)?
what is degenerated dimension?
which one is better performance wise joiner or look up
Name the different lookup cache(s)?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the tasks that can be performed using sq?
draw informatica architecture 8.6 ?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
