DSXchange

Hi All I need help in resolving below example. grouping the data based on the keys(date ranges) for Example Before grouping data A B C D E 100 200 1 1/1/2000 5/1/2001 100 200 1 5/2/2001 8/7/2005 100 200 3 8/8/2005 1/4/2007 100 200 3 1/5/2007 2/1/2008 100 200 1 2/2/2008 6/8/2010 100 200 9 6/9/2010 NU...

Resolved the issue by changing the Key column values. hence marking it as resolved. Thanks for your support

Hi Ray,

Trying this with XMLO stage.

Regards
skumar

Hi, I am trying to load data into an xml file. Source data: - CODE,COL1,COL2,COL3 A,1,2,3 B,1,2,3 Expected outpudata format: - <?xml version="1.0" encoding="UTF-8"?> <PARENT_XML> <PRODUCT> <CODE>A</CODE> <COL1>1</COL1> <COL2>2</COL2> <COL3>3</COL3> </PRODUCT> <PRODUCT> <CODE>B</C...

Ray, Thanks for your suggestion. I tried using semi colon and there is no line terminator at the end of SQL query. Also, when I searched in forum, I found that we should actually call the File as {File}/home/user/abc.sql . So, I tried with this option also but still getting the above error. Does ODB...

I tried with //home//user//abc.sql .But no luck

Hi All, I wanted to read the SQL "SELECT * FROM EMP" through a file in ODBC connector stage. The connection was successful. When I am trying to view the data I am getting below error "ODBC Function "SQLNumResultCols" reported: SQLSTATE=42000:Native Error Code=-104 ILLEGAL SY...

I tried using the loop variables with @ITERATION function. it worked well for me. here is the logic. Stage variable1 - Min Date Stage Variable2 -Max Date Stage Variable3 - JulianDay(MaxDate)-JulianDay(MinDate) Now, In loop constraint @ITERATION <=StageVariable3 In derivation of LoopVar - Dateoffsetb...

Hi All, I have a single record from source which contains minimum date - 2015/10/01 and maximum date - 2015/10/31. Now, In target I want to generate in between dates using loop variables. So my target should contain 31 records including the min and max dates. can some one help me on this. Thanks sku...

Hi All I am trying to insert a XML value into one DB2 column. I am getting the below warning and all records are getting rejected while loading into the table. The target datatype is XML. Invalid character(s) ([xE1]) found converting string (code point(s): <tns:abcs xmlns:tns="http://www.xyz.co...

Hi All

I am receiving the data from my source as below

RP11
Rp2
RP1
RP12

After doing the sorting I am getting the output as

RP1
RP11
RP12
RP2


but I want the output as

RP1
Rp2
RP11
Rp12

Can any one help me that is there any function to achieve or any possible way to do it?


Thanks
skumar

Hi all

I have a requirement that from my source i am getting the date format as "2011335" I want to convert this as "2011-12-01". can any one throw some light how i can do this using the parallel transformer?

Thanks in advance.

Regards
skumar

Hi All I am facing a problem while parameterising the query. I have a requirement to paramaeterise the source query. For Ex: - SELECT * FROM #$SCHEMA#.EMP I am calling the total query in a job parameter. When I declared the parameter as a string the total query is considered as string which includes...

can any one throw some light on this? I am also facing this error.

Hi All I have some codes present in my source data. I am filtering the records through a filter stage and I want to pass that filter values at run time. In the filter I am setting the where clause as input.col='" :pcode12345:"'. At run time i want pass the values as (1,2) or (1,2,3) etc......