I want to insert Decimal(15,2) values to adobe table, The data i sourced from teradata. i could not able create the column with decimal in adobe. what is the matching data type should i set to this column?

Hi, I have autopk turned on but still its throwing error, <element autopk="true" label="SampleDB" name="SampleDB" pkSequence="testSchemaSeq">i dont have my own column as primary key.   

No i tried this. this is throwing another exception. missing from clause ....

I am trying to execute insert operation throught javascript method.  var temp="INSERT INTO gowSampleDB(sSTG_ID,sATTRB_CD,sATTRB_VAL) VALUES ('9383677898998939','GOWTHAMANTEST','GOWTHAMTEST1')";logInfo("My query :"+temp);var strSql = sqlExec(temp);  but its throwing unique constraint exception. How d...

I want to invert the table which i am getting from enrichment. So is there any other way to do this with our SQL code activity? ID  FirstName LastName Email1   Name1       Name12    Email12   Name2       Name22    Email23   Name3       Name32    Email3 i want to convert above table into ID   Attribu...

Hi , I am using SQL code activity to do insert into custom table . From the the below code i want the data from enrichment before sql code activity. Can some one give me sample query to fetch values from enrichment and insert into table.  INSERT INTO Customtable(column1, column2, column3, ...)SELECT...

I don't know how to use SQL activity for this. Any idea?

ID  FirstName LastName Email1   Name1       Name12    Email12   Name2       Name22    Email23   Name3       Name32    Email3 i want to convert above table into ID   AttributeName   AttributeValue1     FirstName        Name11     LastName        Name121     Email                Email12     FirstName ...

Appreciate it.

Hi, I have enrichment with all the data i want.  Now i am trying to insert into table through java script. I dont want to use update sql activity due to some table transformation.  How do i derive the data which populated in enrichment in java script. For ex sqlExec("insert into gow:SampleDB(std_id,...