I have the following data that i need to write in target DB. When i am trying to do the mapping CSV reads the whole data as the record separator is , and field separator is (blank). When dept 2 it needs to read how it will read, and also the target is two tables as per the criteria. How to handle this?
having the tables in target DB as
Dept table columns
Emp table columns
Thanks for your reply.
Inspite of creating two datastore when I am dragging and dropping the tables in target container during mapping of interface, two tables are not coming.
Inspite of having foreign key relationship between the two tables, the tables are not coming in the target container.
An ODI interface can never have two target tables. You have to create 2 interface for it.
An ODI interface can have multiply target under some assumption. For example if your target has got same metadata and a variable in resource name. Statement regarding ODI including "never" and "always" are 95% of the time wrong.