SQL Server MDS : How to Know Actual MDS Table name for Model Entity and Column name for the Attribute

How to Know Actual MDS Table name for Model Entity and Column name for the Attribute .


here is the Script 


USE MDS

------------------------------------------------------------
-- TODO: Define Model name, Entity name, and Attribute Name
       DECLARE @Model NVARCHAR(50)       = '<<GiveModelName>>';
       DECLARE @Entity_Name NVARCHAR(50) = '<<GiveEntityName>>';
       DECLARE @Attribute_Name NVARCHAR(50)= '<<GiveAttributeName>>';
------------------------------------------------------------

-- Set @Table name
       DECLARE @Table NVARCHAR(128);    
       SELECT @Table = EntityTable FROM mdm.viw_SYSTEM_SCHEMA_ENTITY WHERE Model_Name= @Model AND name= @Entity_Name ;

-- Set @Column name       
       DECLARE @Column NVARCHAR(128)

       SELECT  @Column  = Attribute_Column FROM mdm.viw_SYSTEM_SCHEMA_ATTRIBUTES WHERE Model_Name = @Model AND Entity_Name= @Entity_Name AND Attribute_Name = @Attribute_Name;


SELECT @Table as EntityTableInMDS , @Column as ColumnNameofAttribute

Comments

Post a Comment

Popular posts from this blog

SSIS :Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done

when we try to use table name as parameter is Execute sql task in SSIS Then we got this error [Execute SQL Task] Error: Executing the query "delete ? where [group] ='HTTP' " failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. After many trails we came to know that it i snot possible to pass table name as input parameter for the Execute Sql Task . Work Around to solve this issue : Create a Variable to build dynamic query . In the Expression of the Neqvarible pass the Tablename variable . "Delete "+ @[User::DestRateTableName]+ "  where [Group] ='HTTP'" In Execute Sql task select the SQLSourceType as Variable and  select the new variable in Sourcevariable co...
Read more

SSIS Error : Object is not an ADODB.RecordSet or an ADODB.Record + Solution

Problem : I have two script tasks in my SSIS package. The first one saves a string array as a package variable: // In 1st script task: String[] astrCustNames = new String[cust_count]; /* ... * Some code to add strings to array ... */ // Add array to a package variable Dts.Variables["CustomerNames"].Value = astrCustNames; The second task should then extract the strings from the variable. In the past, I've done this with a table variable. The same approach won't work for the string array: // In 2nd script task: OleDbDataAdapter ole_da = new OleDbDataAdapter(); // Fill the customer names data table DataTable dtCustNames = new DataTable(); ole_da.Fill(dtCustNames, Dts.Variables["User::CustomerNames"].Value); The call that fills the data adapter will result in the error "Object is not an ADODB.RecordSet or an ADODB.Record." The .dtsx package lists the data type as DTS:DataType="13" The data type of the variable as it is defined in...
Read more

SSRS : [Teradata Database] 3939 There is a mismatch between the number of parameters specified and the number of parameters required.

Error : [Teradata Database] 3939   There is a mismatch between the number of parameters specified and the number of parameters required. When we get this Error : when we are creating SSRS reports on Teradata database and in which when we are using parameters in the dataset in wrong style\format. Just for Info :  to connect Terdata we need to have  .Net Data provider for Terdata  when we installed this on our machine  Then we are able to see Teradata data source type in SSRS. How to Solve this issue :  This error will come if we are not using correct syntax to create parameterized data set .  The correct way is we need to ?  for parameter The report parameters can be named or unnamed. Teradata only supports unnamed parameters. An unnamed parameter is denoted by a ‘?’, and is merely a placeholder for data that is going to be entered at report processing time. For example, the following is a dataset with a single-value ...
Read more