Solved how to set multiple dataschema configuration as source

Hello ,

i have one mapping where source is used as sql query which is comes from

Mapping is :



1. source query
source server : innmsrlmpddb02
source databace name: LIMS_PROD_DATA

2. target table
server: abc
database : cipla_edw. it succesfully run

as bellow :




now i want to set dataschema configuration on source so that i can switch between source.

so i was created dataschema configuration named as dev
where

server:xyz
database:PQ_DRY_RUN

as bellow



but it gives error that 'LOT' table object is invalid


please suggest solution


Regards
Nikita Barve

Hi,

It seems there is no schema name in the executed query.
For the schema provided in the configuration to be properly used in query you should do the following:

1. Create a metadata link to the default shema by sliding it from object explorer to the query in metadata explorer:

2. In the query in place of schema name use the following syntax:
{$HOTEL_MANAGEMENT/tech:physicalName()}
In my example it looks like this:

Of course you should change the HOTEL_MANAGEMENT part to reflect the name of the metadata link that you created.
After this is done the schema in the query should be properly substituted by the schema name defined in the configuration.
Please let me know if it worked for you.
If you still experience problems do not hesitate to contact Stambia Support.

Kind regards,
Adrian

Hello ,

i tried these but its gives me bellow error.



these creates nested query, and also didn't find schema name.

but if i tried these with sql operation it gives proper answer with schema name . bellow is screen shot



Please suggest solution

Hi,

What is the name of the metadata link in your query?
Can you try using it instead of "." like explained in my previous message?
For example:
select top 10 * from
{$MetadataLinkName/tech:physicalName()}.C_INVEST_ANA_FAIL


Best regards,
Adrian

Hello ,

yes i tried this, it gives same error. please suggest solution.

Thanks & regards
Nikita Barve.

Hi,

I have tried this and it returns nested query if you use the "." but it works fine with the metadata link name as suggested above.

Have you saved the metadata after you changed the expression in the query and before trying the reverse?
If not, the designer takes the last saved expression (so the one with ".") and therefore would give you the same error.
Also, please make sure that the metadata link you are using is a link to a schema and not to the table.
The one you used on Sql operation is a link to a specific table not a schema.
If you want to use this link you need to use the following expression:
select top 10 * from
{$C_INVEST_ANA_FAIL/tech:physicalPath()}

If you still cannot make it work I suggest you make an export of your metadata and send it to Stambia Support so they can have a look.

Best regards,
Adrian

Hi,

Thanks , its working properly.

Thanks & Regards,
Nikita Barve.