DSXchange

HI,
I have to convert Date format to Gregorian format, can any one suggest me how to do this, i searched but i didnt get the answers
Any suggestion is appreciated,

Thanks
Ravi

Hi,
Use Convert Function in Transformer , covert it from || to '' ,it will work

Regards
Ravi

Hi Ravi, Schema file is used to pass the metadata to a job/ stage and not the data. The schema file should contain the metadata ex. field names, data types and length. The definition of a schema will be something like this record( Field1:String[10]{delim=none}; Field2:String[10]{delim=none}; ) HI, ...

Hi, In Row generator stage i have taken schema file option and i have given the file path and name. and my file contains data like say for ex : 900,e 1000,f 1100,g 1200,h but when iam trying to view data from row generator iam getting the warning like :Caught ORCHESTRATE exception in main program: A...

Hi, I have a scenario where in there are 2 columns if both the columns have null values from the source then -2 should be harcoded and if any one of the column is null then the column should be rejected and if both the columns have values it should pass with the original values. for ex: Col1 Col2 C...

Hi,
No Need Transformer stage ,you can use copy stage ,have two output links and rename the 2nd link column names to first link column names before funneling.

Hi,
Iam running a sequence ,in that sequence iam using a routine activity to call a script, the sequence got aborted by giving the warning
/bcpsetenv.ksh:" ,but when iam running through putty the shell script is working fine.
Any one has any idea

Thanks in advance

Hi Iam loading data in to a fixed width file , in the target seq file in the format tab i have selected the fixed width columns option, the job is finished with full of warnings, one warning is: mergSystemsSMEReward_eb..DTL.DTL: put_fixedwidth() - data for column SYST_ID exceeds column width (4), ro...

Sainath.Srinivasan wrote:What is your source ?

As you have mentioned this as Server, is the source a sequential file or a table ?

If table, you can do a select count upfront.

If a sequential file, you can try someth ...

Hi,
Thanks for your reply ,Can you plz paste it , as i dont have premium account.

ray.wurlod wrote:@INROWNUM ...

@INROWNUM gives the incremental number for each record, but i want the count of the records coming from source

Hi, How to get Record count in Transformer , i dont want to use aggregator, iam trying but not able to get the record count,is there any way to find the count ,i think we can do it through routine activity can any one suggest me how to do that ,bec till now i didnt use any routines . Thanks in Advance

Hi,
iam reading a file from file set with extension .fs ,having 3 fields
Iam Not able to view data at all , the warning iam facing is
"file entry must have a hostname"
can any one help on this plz..

Thanks in Advance

i dont have premium account can you plz paste it

Hi, While extracting data from the oracle stage and loading in to the hash file, 36 million records need to load in to the hash file but after showing performance for 18 million records the job got aborted and getting the fatal error xfmHKHOGANAcctMsttoHfile..HGN_ACC_MST_BAL_DEP.To_HgnCstValidation:...

Hi, iam just loading data from oracle stage to hash file , after loading some 18 million records the job got aborted and iam facing the warning jobname.hashstagename: ds_uvput() - Write failed for record id '15-APR-10 57010762024' can any one plz give me the solution Thanks in advance Regards Ravi