DSXchange

Hi all, How to load data into Dimension table. The following is my requirement We have Dimension table as Gl_Acct_Dimnsn ,it contains columns like Gl_Acct_Id,Gl_Acct_Nbr,Gl_Acct_Grp etc. We have to load the Gl_Acct_Nbr from source table (which contains column Gl_Acct_Nbr) to Gl_Acct_Dimnsn table. I...

Doesn't matter what you 'expect' it to be, what is the exact value you are attempting to set it to when it fails? Write sumFile1 to your log file first so you know. Yah it is giving the value correct as sumFile1= CODE_SRC_Datesuffix_I.txt in the log info but the log in the attached job shows blank ...

Have you looked up what an error code of 4 means? It equates to DSJE.BADVALUE and means "Parameter Value is not appropriate for that parameter type". So... what type do you have the parameter defined as and what value are you trying to set it to? We have set it as String and we expect it ...

Sainath.Srinivasan wrote:Include a

Code: Select all

 Call DSLogInfo('File Name - ' : FileNameX, 'Test')

after
the EReplace line and once just before the DSSetParam line.

Hello,
yah I have again edited the post and facing the same ....
Thanks

Sainath.Srinivasan wrote:Did you include the change mentioned in my last post? Are you getting the error even then?

Yes,

[quote="Sainath.Srinivasan"]It appears that you have edited your earlier post.

Yah still we are getting the following error

LoadReportsControl..JobControl (this): ErrCode-4

Sainath.Srinivasan wrote:The DSSetParam line says

"FileNameX, "

whereas it must say

", FileNameX"

Hi
Thanks but it will take string not as a variable

Hello Dear members I'm facing the problem like... I have the job controller which calls the attached Job,the controller has to take the file name from Unix dynamically and pass the same to the job as a parameter, but it passes all parameters except the file name,can you help ? the following is the c...

Dear Friends when I want to compile it gives the following error pls help, the same sequencer under the same project runs in other client system but in my system this error . Thanks Sushanth <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system cann...

Dear vmcburney
Where I can get this evaluation version can I also
get non disclosable agreement pls elaborate
Thanks
suashanth

Yah As Mr ray says it must be the reason to convert InFormatica maps into DS jobs thts right. I do agree

Thanks, then we are not doing any sorting or Partitioing at the earlier stream means preceding stage (?) still we get this error.

Two Datasets are joining into a Target DB2 table with left outer Join In all the stages, Iam making Sequential mode enabled then I receive all records which Iwant in the target but with a warning like "When checking operator: Sequential operator cannot preserve partitioning of parallel dataset ...

Check the datatype size at source and target file

We are Using Modify stage to add columns and also to add basic function like calculation in the derivation column but there is a binding error like syntax for the formulae ? So can we use the modify stage for that CAlculation.
pls highlight
Thanks
Yours
Sushanth