RE: can anyone help me if i add a column in my flatfil...
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.
RE: can anyone help me if i add a column in my flatfil...
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?
