DSXchange

Hi All, We have a job design in server where the same table is reading and writing and then reading, in 9.1 server we have a sparse lookup with ODBC enterprise stage with transformer but before that the same table will be writing the data and the written data is extracting in the next stage. But whe...

Hi All, 9.1 datastage version we have designed one job which will have multiple insert statements in ODBC enterprise stage in Server job which is executing successfully. But when we tried to migrate the same job to 11.5 and replacing ODBC enterprise stage with connector and triggered the job but ODB...

Hi , I am getting a very weird issue when using xml file. My xsd has the pattern value as <xs:pattern value="[a-zA-Z \-]*"/> (size 40) which accepts a to z letters capitals and smaller plus '-' in between the word. My New xml file having item code like 'Honda-model-B' which is throwing enu...

Hi All,

I am writing command (dsjob -lognewest <ProjectName> <DSJobName>.<InvocationID>) to get the latest log but when I trigger multiple jobs in parallel, log is extracting from main job not from the invocation job. Can you suggest what needs to be changed here.

Thanks alot Ernie...!! When i take only one record and view in IE ....Its perfect record..!! Unfortunately ... i need to send the xml file to downstream and they are not able to read the file. When they modified the file to have " instead of " they were able to process the file. Hope a som...

Hi , Thanks alot, Solution worked and i am able to create the records in required format. I am not sure why i am getting the " for double quotes inside the namespace. Please suggest me how to get get the double quotes. Issue is only with namespace. Let me give the options what i used. Seq stage...

You need to fully release the xml for each group of incoming rows that define a whole body. Set up a sort key and put the incoming rows in the order by each desired body and then use trigger column ... I tried it, but i am still not getting the proper result. Below is my understanding, Please clari...

Hi, I have a requirement to create a single XML output file with multiple headers. For example, if I have 3 records coming to my XML stage, then I need to have header for each record. Sample expected output format below. <?xml version="1.0" encoding="UTF-8"?><TCRMService xmlns=&q...

Hi All, I have requirement that group by ID field fetch the value from Current Location/Current Role based on the Maximum date, if value is blank for the maximum date then fetch the previous date value and so on. And fetch the value from Previous Location/Previous Role based on Minimum date, if valu...

Hi Mr suhaskool,

First let us know what you have tried from your end, try something from your end before posting here.

It's very much simple, if you can tell what you have tried then I will provide the logic to implement the same.

Hi All, I am trying to fetch the data from SOQL Database using sales force connector server Package. When I tried to define column metadata I can see data in dataset but when I use RCP without defining columns Job is getting successful but in dataset all values are coming as blank. Anyone knows the ...

Hi rkashyap,

I tried to do this in unix itself and tried below command

awk -F',' '{print $1}' test2.txt|sort -u |awk '{printf "\\'"'"'" $1} END {print "\\'"'"'"}'

but it's displaying output like
\'A\'B\'C\'

But I need output like below
\'A\',\'B\',\'C\'

Hi All, Below is my source file format. Account name,city,value ABC,hyd,1000 DEF,ban,2000 ABC,Chn,3000 GHI,US,3000 JKL,UK,4000 DEF,us,6600 I need to find unique records I. Account name column and all unique records to populate in single line like below. Output: /'ABC/',/'DEF/',/'GHI/',/'JKL/' Please...

Hi,

Datastage default CurrentDate() format is %yyyy-%mm-%dd

so use below logic to extract the current year from CurrentDate() function.

Left(CurrentDate(),4)

Hi,

Use below logic.

If Trim(Input_Column)=0 Then SetNull() Else Input_Column