DSXchange

FTP Enterprise stage is creating a 0 byte file on the target server if there is no such file in the source server directory. As there is no such file in source directory...Job obviously aborts and its doing correctly but when I see the target server directory, I see a 0 byte file Seq File stage ----...

Can you please provide more details. What schema name is that. As you know, Salesforce is object names based driven and when you select the option "Get the Bulk Load Status" you wont have any option to give any object or schema name but the JobID FIle name path or Just JobID Thanks in adva...

1)First do group by on cola,colb,colc and sum on cold 2)Now split your flow into three streams based on your colb(1,2,3 based) by using transformer or filter stage. 3) Now try to join them back based on keys cola and colc only do not use colb in join Do full outer join on that. whichever output valu...

I am using salesforce Connector stage and trying to do "Get the Bulk Load Status" I am getting below warning with zero records out. "Unable to get bulk load job status Invalid Schema for checking bulk load status" I am using the correct JobID and using following four columns in t...

Tried from different client machines and the issue is the same. But just trying to work on node agent of services tier and let me see if that works. Will get back if that is resolved.
Any other comments suggestions are really appreciated.
Thanks

Hi When you click on view data in any connector stage or when you click on browse objects in Salesforce connector stage during design time, could you please let me know where does the connector hit. I checked, and it doesn't hit the engine. Not sure if it hits the services. I was trying to click on ...

Extract the month part alone. Check if month is 04,06,09,11 then append 30 to the existing string. Else if month is 02 and (Year%4)=0 then append 29 Else append 31 to the existing string. we are missing Feb 28 Month ending in this logic and how can we handle % datastage transformer The above can be...

ReachKumar wrote:Adding one more point :
Logic to findout Leapyear:

If (Year%400 = 0 ) or ( Year%100 <> 0 and Year%4 = 0 )

% dont work in transformer..wat would be the function instead and also we are missing fed 28 month ending

ReachKumar wrote:Adding one more point :
Logic to findout Leapyear:

If (Year%400 = 0 ) or ( Year%100 <> 0 and Year%4 = 0 )

% dont work in transformer..wat would be the function instead

Can any one give me the solution for below question using datastage Transformer or any solution using DataStage. Can any one suggest how to get the last day of a month based on my source data For Example I am getting from source 200812(year and Month) Then my output should be 20081231(end of that mo...

Can any one suggest how to get the last day of a month based on my source data For Example I am getting from source 200812(year and Month) Then my output should be 20081231(end of that month and year) Say one more example If I am getting 200802(Year and month) Then my output should be 20080229(end o...

Hi All, I have a requirement to split the incoming data based on a key column data comes in as: Key column column2 column3 column4 A 1 2 3 A 4 5 6 A 19 20 21 B 7 8 9 B 10 11 12 C 13 14 15 C 16 17 18 and so on.................... I need all As,Bs,Cs in separate O/P links. Help appreciated. Thanks in...

Hi I am moving some table data into a .csv file or .xls file using datastage. Just want to have the column names in that .csv file or .xls file cells in high lighted colour. Can you do it with some transforer stage with colour code ? A B C D <-------column names or those spread sheet cells in high l...

Then try to map the Varchar Column to Decimal without using any function to the target file. For your records your varchar(9) should be mapped to Decimal(6,2) I do had a situation like you, and used the above solution which worked fine! (In 7x) :roll: :!: TRIED, but did not worked, still loading as...

Then try to map the Varchar Column to Decimal without using any function to the target file. For your records your varchar(9) should be mapped to Decimal(6,2) I do had a situation like you, and used the above solution which worked fine! (In 7x) :roll: :!: TRIED, but did not worked, still loading as...