DSXchange

Please try to use Dynamic RDBMS stage to retrieve CLOB data... select datatype of column as Longvarchar but do not menion any column length... it works for lengthy CLOBs also.

Hi, I am writting data in Dataset, which has few columns defined as Not Null. All the values are properly populating in the dataset. But when I am looking the dataset schema in Data Set Management, it is showing 2 columns as NULLABLE. However I have declared those columns as NOT NULL. Run Time Colum...

It is giving error in the Oracle stage only. I am taking oracle data into dataset. I am not converting any data and just copying the oracle data. I am not using user defined SQL. I am using same metadata, what I have imported using metadata definition. Also I am not mapping CLOB data to decimal. Eve...

Hi, I am trying to read the CLOB data type column using Oracle OCI stage. when I imported the metadata, it has given Longvarchar(4000) but after running the job is has aborted with the following error message: Implicit conversion from source type "decimal[10,0]" to result type "string...

Hi, I have input as follows (2 records) in XML file: <mandatory>true</mandatory> <subsection></subsection> <question>XYZ</question> <currentQuestion>false</currentQuestion> <mandatory>true</mandatory> <subsection>123</subsection> <question>ABCD </question> <Question>false</Question> When I am extrac...

Thanks for all your replies. I have searched the topics but I have not got any suitable reply for my input set of data. If you see the input set it has two pivot columns ID and SECTION. It would be greatful if anyone can provide solution to this example. Input Data: ------------- Id Fname Sname Sect...

Thanks for all your replies. I have searched the topics but I have not got any suitable reply for my input set of data. If you see the input set it has two pivot columns ID and SECTION. It would be greatful if anyone can provide solution to this example. Input Data: ------------- Id Fname Sname Sect...

Hi, I have a requirement to pivot the multiple rows into a single row. I have input data as below: Input Data: ------------- Id Fname Sname Section Ques Ans -------------------------------------------------------------------- 100 Sam Roy S1 Q11 A11 100 Sam Roy S1 Q12 A12 100 Sam Roy S1 Q13 A13 100 S...

Hi, I have a requirement to pivot the multiple rows into a single row. I have input data as below: Input Data: ------------- Id Fname Sname Section Ques Ans -------------------------------------------------------------------- 100 Sam Roy S1 Q11 A11 100 Sam Roy S1 Q12 A12 100 Sam Roy S1 Q13 A13 100 S...