DSXchange

Hi all, 1) Source ---> transformer -----> peek stage. If records coming out of transformer is 1000, all the 1000 records will be seen in the job log(output option = job log) or if i set in peek stage as 10 records per partition, only first 40 records will be visible in case if it runs in 4 nodes? 2)...

Thanks chulett. I will try to find it out.

Sorry for posting it again. I thought i will get some answer as the query will appear in the top of the stack.

Apologies

As mentioned, i tried with StringToDate(UStringToString(lnk_scAuditKey.timestamp),'%dd %mon %yyyy'). Input format is 30 jul 2011 11:30. I tried with StringToTimestamp also. in the format of '%dd %mmm %yyyy %hh : %mm : %ss'. But that also not working. Error : Data string '30 Jun 2011 ' does not match...

Thanks jwiles.

Hi all,

Where can i enable or disable operator combination option?

Hi all, I just have a job with source ---> filter ---> copy ---> transformer ---> target. I have given auto here in one run for all the stages. Another run, i have given as round - robin at the first partition setting and "same" in the rest. I understand if i set specific partition methods...

source & references are different dbms.

Hi all, I have a varchar column coming the source(ds) which needs to be converted to date (target oracle's default date format). Format eg : 11 jun 2011 11 : 30 This needs to be converted to oracle's standard date format. I tried in transformer using stringtodate(inputcolumn,'%yyyy-%mm-%dd'). I give...

Hi guys,

Please help me regarding this query if u get to know.

Thanks in advance.

I understand your point. Apologises for that. I dint say its urgent. I just asked help me in this query. I wont use names anymore. But sometimes questions goes unnoticed as so many posts are there in the queue. So i just send a reminder in common. Regarding the query I will check it out. Please tell...

I accept your point. But if you had answered the query along with this means, it would have been better.


Thanks in advance

Hi ray,chulett,jwiles

Please help regarding this query.

Thanks in advance

Hi all, i have a job in which i use six lookups with each oracle enterprise stage to do the join. But the record count is very less in each stage. So one lookup stage itself will do fine. but any performance problem if i use 6 lookups where 1 is sufficient. I know for big reference data in all 6 tab...

Hi all,

Any suggestions regarding this query..

Thanks

Thanks chulett. Anyway in which i can avoid the second run of the sequencer by putting a condition in the start of the sequencer itself. I am asking with the capability of the sequencer stages and built in parameters. Do we have any built in variable which will store the last run date of a particula...