Oracle dimension tables to Azure ADLS
We’re starting a project to move dozens of Oracle warehouse dimension tables to ADLS, and are using parent/child pipelines to pass table names. The pipelines correctly pass and resolve the table na...
Forum Discussion
Is the SQL Server on-premises or in the cloud?
If on-premises, are you using a Groundplex?
@dmiller it is on-premises, and yup, using the Groundplex.
Could it be the SERVERNAME\INSTANCENAME format as hostname?
@pranil2k2 - You can access your document inside template body by enabling “=” (toggle) expression mode. eg: ‘<body>’+$firstname+‘</body>’. you have multiple ways. Can you share sample output from mapper snap and your template to help further.
In Mapper i have two columns, and i need to configure in mail to show the table name and its stats.
I am trying using below template as suggested in document but it is throwing error. is there any standard format to refer other than below?
SMRT Load StatsTable Name
+$$Table_name+
<p>Table Stats</p> <p>+$Table_Record_Count+</p>Thanks Again
"
SMRT Load StatsTable Name
+$$Table_name+
" i think it got broken<p>Table Stats</p> <p>+$Table_Record_Count+</p>@pranil2k2, Just make sure you are passing array of JSON object to email Snap as shown below and Table-data path is set to $
Hi, how would this work if I wanted to output multiple tables in one email body? Thanks.
Hi Sadasivam,
Thanks for the reply. I am trying to use HTML Text option. but i am getting below error.
for now i want to pass single table stats,as mapped in mapper.i want to display $Table_Record_Count, $Table_name values in Mail. please can you give some example on this scenario and if possible please share me the pipeline for reference.
Thanks Again.
Hi,
I tried to implement your method using Table but it is throwing error.
Below is the syntax used in Mapper
[{‘Table Name’: $TABLE_NAME,‘Count’:$COUNT}]
