Scenario:
Need to populate employee hierarchy for that technical team
provided the SQL. I have to build ODI mapping for that. I decided to use SQL as
it is.
Steps:
1.
Drag and Drop Target datastore twice on to the
Mapping editor
2.
Select first datastore and change the alias name
as “SQ”
3.
Select Second datastore and change the alias
name as “TRG”
4.
Go to Physical
5.
Select “SQ” and go to property inspector and
expand “Extract Options” à
Go to “Custom Template” and in place value provide your SQL
6.
Connect SQ output connector to TRG input
connector
7.
Enable auto map
8.
Run the mapping it load the data to Target table
Hello Trinesh,
ReplyDeleteCan you please provide the SQL placed in the value.
Thanks,
Amirtha