Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert Single row(Source) into Multiple rows(Target) - ODI !!!!!!!!!

632265Jun 24 2008 — edited Jun 25 2008
Hi All,

Is it possible to convert a single row into Multiple rows in ODI interface or procedures.

My source and Target tables are in Oracle Databse



Example:

Source Table :
----------------------------------------------------
EMP AGE CITY
---------------------------------------------------
101 24 ABC

Target Table :
------------------------------------------------
EMPID AGE CITY
---------------------------------------------------
101 24 ABC
101 24 CAD
101 24 BCS
101 24 KIT
101 24 LOT
101 24 NIT


I can say in this way in my source I will have single record.

My requirement is to translate the single row into multiple rows for which the only difference will be the data present in the CITY column will be different ....that will be the only difference all other data will be same for other columns( no issues abt primary key combinations)


Thanks in advance

Thanks
AK

Message was edited by:
Ananda

Message was edited by:
Ananda
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2008
Added on Jun 24 2008
#business-intelligence-applications, #data-integrator, #system-management-and-integration
10 comments
1,768 views