DSXchange

Hi I am scheduling a sequence using cron tab ,I have the add checkpoints options clicked , 1.When the cron tab fires the sequence again will the sequence be reset or it just runs from where it failed when the job aborts 2. when the sequence aborts and I want to reset(clear check points) and run it f...

Hi I am joining data on a feild which is of varchar unicode type .When I convert the feild to Nvarchar type I get a different output than when joined on varchar and varchar unicode types. What if the difference between these data types when used as joined key is NVarchar similar to Varchar with unic...

Is there any change in data? What is the data type been used? I once faced the problem with the APT_PADCHAR property. The file produced by another job was with different padchar and hence messed up. There are some unicode feilds in one input to join on which I am joining the data ,before the join s...

HI In some of my jobs I am facing weird problems ,I am using join stage to join the data ,Everything works fine in development env.but when I promote it to production ,the data is not joining and to the surprise not even a single row gets matched which produces almost 100,000 rows as output in devel...

No, but only because it's illegal SQL (not a DataStage issue). You need HAVING instead of WHERE. That said, your metadata (table definition) requires one Integer column whose derivation is COUNT(*) and four other columns to match the other columns in your query. . Yeah you are right ,I am sorry I m...

Hi
Can we impliment this query in data stage

select count(*) ,col1,col2,col3,min(col4) from #table1 (which is output data from transformer) group by col1,col2,col3 where count(*) > 1

Thanks in advance for help

ARif

Hi A sequence needs to be fired every hour by cron tab ,but some times it takes more than one hour for sequence to run ,so when the cron tries to fire it again while its still running I get a warning DS.SCHEDULE;Job Must be reset before run Does somebody have any idea how to get around this problem....

kumar_s wrote:Are you sure there is no change in the job. What about the unicode for that particular field in that job?

Everything is exactly the same

Hi
I am using UTF8 charecter set ,some of my jobs that runs without a warning ,genertes a warning Coverting Ustring to String if ran in protected mode in production environment .

Does anybody else have encountered this problem before.

Thanks
Arif

I was able to resolve the issue in a couple of jobs. I was using the SybaseOCPX stage with "Generated SQL query". However, I didn't have the "database owner" with the table name. Thus instead of using "Owner.dbo.TableName" in the "Table Names", I was using &q...

No the sequence itself does not reset automatically. If you compile it then it will not restart at the point of failure. The jobs within the sequence will reset themselves if you select that option on the job activity. Most of the time the sequence does not abort. It finishes with a warning. I sequ...

1.What is the error message you are getting?( Is it Job A has to be reset before it can be run?) 2.When Job Sequence B fails, what is the status of the Job sequence A.Is it in Aborted Status or Finished status. If a Job is scheduled at particular time, and if that job aborts(finishes with status=3)...

Hi I have a sequence A which calls another sequence B(with option reset if required then run ),A is scheduled to run through cron tab,if B fails ,A is not able to restart in the second run . What are the add check point options to be selected in both sequence A and B so that A can be restartable in ...

It would be sufficient to hash (or modulus) on zip. Sorting on the other two columns is beneficial to the correct operation on the Remove Duplicates stage, but all you need to ensure is that each distinct value of zip (the grouping column) appears on exactly one node. . I tried sorting by apt first...

Yes. But... Why partition on all three? Or is this just an example? All partitioning is used to do is distribute data evenly across multiple independent worker processes. Hash partitioning means that like values stay together, which introduces some skewing as a 99K out of 100K rows may partition to...