How to generate new records using export datasource

[Sujai]

Hi

I have an ODS with the fields field1, field2 and field3. I have another ODS say ODS2 that has the fields field2, field3 and field4. Now for each record in ODS1 I have to insert multiple records in ODS2 from ODS1 and also populate field4 of ODS2 by fetching some values from a ztable using some logic.

I have created an export datasource of ODS1 and I am trying to do the coding in the start routine of ODS2, is this correct? and since the data package structure does not have the field4 how can i populate this field in ODS2?

Regards,

Sujai

[Sujai]

closing thread

[Former Member]

Hi,

you can add the field to ods1 or you can populate an internal table in the start routine and get the desired value for field4 from the internal table in a infoobject routine.

regards

Siggi

[Sujai]

thanx Siggi and Venkat

will try it out.

but how to increase the number of records for the ODS2?? should i add the new records to the data structure or the internal table??

Sujai

Edited by: Sujai S on Feb 26, 2009 10:40 PM

[Former Member]

The data structure will not have feild4 but the update rule structure will have feild 4. So in the update rule using a routine you shoudul populate the data for field 4 based on feild 2 and 3. What you atre doing is right.....

[Former Member]

Hi,

you can add the field to ods1 or you can populate an internal table in the start routine and get the desired value for field4 from the internal table in a infoobject routine.

regards

Siggi