HI
*sql
in datawarehousing*
i was using the ETL tool INFORMATICA - version 6.2 . and i am creating a
TARGET TABLE manually, in oracle database. using the option Targets >
create.
created the table with generation options like create ,not null , drop table
. and added all the columns. and saved it.
then i did rename the table and when i viewed the data in the renamed table,
its gone. only structure is available but no data .
what shld i do not to loose the data next time and also how can i getback
the lost data in the above case.
thanks in advance.
