How to delete the (flat file) data in the target table after
loaded.
Answer Posted / james
whatever data u want to delete from target table,simply go
with truncate option.
| Is This Answer Correct ? | 1 Yes | 14 No |
Post New Answer View All Answers
Informatica Checkpoints
When do you use sql override in a lookup transformation?
Please let me know how to make Data masking in informatica..
what is SDLC way of code development?
lookup transformation with screenshots
What is update strategy transform?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a difference between complete, stop and abort?
How many dimensions are there in informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is Cognos script editor?
In informatics server which files are created during the session rums?
Design a mapping to load a target table with the following values from the above source?