OraFAQ Forum: Data Integration » Joiner

Home » Developer & Programmer » Data Integration » Joiner - Output names

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Joiner - Output names [message #239759]

Wed, 23 May 2007 04:33

Snowblitzz
Messages: 8
Registered: May 2007

Junior Member

In OWB i have to make a lot of mappings and have to join even more tables and it would be realy usefull if i can automaticly connect the output fields from the joiner with the new table.

In my new table i use the same fieldnames except with the table name in front of it

Example:
Persons(ID, Name, Age, ...)
Teachers(ID, PID, Name, Age, ...)

combined it will be put in
Collection(Persons_ID, Persons_Name, Persons_Age, Teachers_ID, Teachers_PID, Teachers_Name, Teachers_Age, ...)

now i wish there was a way i can put the table name (or sysnonyme) automaticly in front of the output names.

Now it becomes like
ID
Name
Age
ID_1
PID
Name_1
Age_1
...

can someone tell me if this is possible and if so how..
i heard someone say he saw it at some version but he doesnt know how. im working with version 10g (10.2)

Hope someone can help me .. it should save a real lot of work.

Report message to a moderator

Re: Joiner - Output names [message #239782 is a reply to message #239759]

Wed, 23 May 2007 05:10

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't use OWB so this might be a nonsense from your point of view, but let me try ...

In SQL, you'd use column alias, such as

SQL> select d.deptno dept_dpt_number, e.deptno emp_dpt_number
  2  from dept d, emp e
  3  where d.deptno = e.deptno;

<snip>
DEPT_DPT_NUMBER EMP_DPT_NUMBER
--------------- --------------
             20             20
             30             30
             30             30
</snip>

Although both columns are named 'deptno', I used aliases.

Perhaps you can do the same; your code might then look like

                             v-------- aliases
Collection (Persons_ID     PERS_ID, 
            Persons_Name   PERS_NAME, 
            Persons_Age    PERS_AGE, 
            Teachers_ID    TEACH_ID, 
            Teachers_PID   TEACH_PID, 
            Teachers_Name  TEACH_NAME, 
            Teachers_Age   TEACH_AGE, ...)

Report message to a moderator

Re: Joiner - Output names [message #239792 is a reply to message #239782]

Wed, 23 May 2007 05:44

Snowblitzz
Messages: 8
Registered: May 2007

Junior Member

First off thanx for the info!! nice examples altho i cant use them here.

in SQL and PL/SQL its not realy a problem, then its just adding an alias indeed. but im working with Oracle Warehouse Builder (Design Center). In this program im making a join and the names automaticly are given an sequential number if they are found multiple times (same names in other tables).

Now what i need is to add the table name as a prefix (i can skip a fixt survix when joining the tables, but when joinling like 20 tables these wont work becouz i have 20 differend prefixes.

Still hope someone can help me out.

Report message to a moderator

Previous Topic:	How to preserve the links while reconciling
Next Topic:	Ab initio

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 16:36:49 CST 2024