DSXchange

kduke wrote:One day only on the less colorful logo. Okay?

I ll wait for your next change.

bucks wrote:Thanks kumar and for all the replies,

I have used lengthy procedure for this conversion using function DateFromDaysSince(), using stage var.


Funny thing is, it worked with simple StringToDate(datefield,"%yyyy%ddd").

Do you mind marking the post as resolved.

Hi Mohan,

Iconv/Oconv are BASIC function used in Server jobs, and Basic Transformer in PX jobs which are seldom used.

chulett wrote:Yes, both - and it depends on whether your scheduling request is a 'recurring' request or not....

Cool

If the issue is the parameter, are you sure you are assigning the prarameter correctly? Hope you know that its case sensitive. Use click option to assign parameter.
If you are all sure about that, to check the value, try "echo #parameter#" and check for output in log.

Couple of things: - It is faster to write to a sequential file than writing to a hashed file. - It is faster to read from a sequential file than reading from the database. P.S. (In most cases) May be because, 1.it need to apply the Hash algorithm for each field 2.Connection to the database need to ...

Or use, Sort stage with KeyChangeColumn and filter those rows with the value 0 for duplicate stream, and 1's for Main stream.

Is your server and client on same machine? What is the version of your Windows? Each type of file system has its own restriction of maximum file size limit. Check if it falls under any of such category. So could you confirm that, if the same job is been processed with less number of rows, it gets pr...

But OP is confirming that JobMon is running, may be its better to recheck the Environmental variable value, True or False.

I had a installation of MCM this morning as well. Went without any issues. Able access all clients wihtout any issues.
Just give a try from Command prompt, execute the director.exe or manager.exe from respective folder.

Could you clarify my other question, were you able to see the performance statistics from any other machine (apart from the two what you were using) for the same Project, possibly same Job?

Hi and Welcome to Dsxchange :D !!!!!

Try using

Hi Welcome aboard :D !!!! Career in DWH requires a sound business knowledge of the domain along with analytical skills to identify patterns.There is a lot of demand for DWH specialists. If you find any consultancies, you can find huge opening for Datastage professionals. There are many articles ther...

As noted, you can try writing into dataset, and later you can convert Varbinary into varchar in Sequential file.

Hi Bob,

What you mean, "locally and globally."? You mean do you have seperate profile for mount where the installation is?