How to load to the target which already contains data

Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.

Questions by boobathi

Showing Answers 1 - 5 of 5 Answers

Harikrishna Reddy

  • Jun 2nd, 2006
 

If your target is database

Alter the target table with new field.and reimport the target and source in warehouse designer and source analyzer.go to mapping connect the field from source to target.add one lookup on target table take newly added field returnport and create one fileter check lookup return value is null those null records only populate into target.

  Was this answer useful?  Yes

boobathi rajan

  • Sep 19th, 2006
 

thanks hari

  Was this answer useful?  Yes

nivekiran

  • Sep 13th, 2007
 

When i tried reimporting the target, I was not able to view data in target file.I received error message :: Invalid Identifier". However I tried to rename the file instead of replacing the existing file when reimporting target. It went thru fine. Can you please explain me why I recived error message?

  Was this answer useful?  Yes

Jaspreet_banga

  • Jun 8th, 2011
 

First of all alter the old target table in oracle and create another new table using query as CREATE TABLE  new_table  AS SELECT * FROM old_table, now import this table into the target instance and pull it into the mapping instance window , connect it with source and just check out !..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions