How to delete the (flat file) data in the target table after
loaded.
Answer Posted / vaishali bisht
whenever we load data in flat file it automatically override the old data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to use pmcmd utility command?
Can anyone tell me the new features in Informatica 9 Version?
Which files are created during the session rums by informatics server?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to generate or load values in to the target table based on a column value using informatica etl tool.
How can you generate reports in informatica?
How to open an older version of an object in the workspace?
What is a code page?
How to do unit testing in informatica? How to load data in informatica ?
Describe data concatenation?
I have a flat file, want to reverse the contents of the flat file
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
generate date / time dimension in informatica
How to create a non-reusable instance of reusable transformations?