add twice template table as target

dataservices job design
1

Hi
It’s my first post so - Hello everybody :slight_smile:

I have small problem - how can i add in another DF (but in the same job) second time the same templete table?
First one it isn’t a problem but when i want to add second time a can use my template table only as source

RaDoSZ :poland: (BOB member since 2011-03-03)

2

Hi RaDo,

We can use template table as a target in one dataflow only. we can use the same template table as a source in different data flows.

Thanks & Regards,
Ramana.

Ramana :india: (BOB member since 2009-04-30)

3

Thank’s Ramana for answer

I know - i can use in one DF templete table as a target, and in the second DF as a source, but what when i want to use the same target table in another DF?
In my current project i have this situation and i would like to know how? :slight_smile:

RaDoSZ :poland: (BOB member since 2011-03-03)

4

Sorry, you can’t use a template table as a target in more than 1 dataflow. If you want to use the table as a target in a different dataflow, you will have to import the table.
To do this, locate the appropraite datastore and right mouse click on the template table. Select the ‘Import Table’ option and then your template table will become a real table.
Let me know if you need any clarification.

Nemesis :australia: (BOB member since 2004-06-09)

5

A template table by definition has the structure of the input. So what structure would the template table have in case it is used in two dataflows as target? As there is no way we can guarantee they are identical, we do not allow that in Designer. Note that Designer is inconsistent, you could replicate the dataflow with the template table as target, then you have two dataflows with the same template table as target.

The other approach would be to use just one dataflow with one template table as target and by placing a Merge Transform upfront you can union-all the data of the different sources.

But template tables are for development only, so sooner or later you need to replace them with regular tables anyhow, that’s why I would support Nemesis post.

Werner Daehn :de: (BOB member since 2004-12-17)

6

wdaehn - thank you for rosolve my problem
Nemesis - thank you for your answer

that is what i mean!

In my current project i have this situation (two the same tmp_table). In future i havo to change it.

Thanks for answer

RaDoSZ :poland: (BOB member since 2011-03-03)