DSXchange

ray.wurlod wrote:Alert your BA to the fact that that decision will mean that week #53 in the year has fewer than seven days, and that roll-ups by week will be invalid.

Yes, rollups will be a problem, never though of that. What is a possible solution for this dilemma ?

As far as I can ascertain, the first day of the first week starts on Jan 1st of the year.

oh, ok......guess I gotta find out the business rule required here then. Or just do it like DSguru suggested.

Thanks for the answers.

Hi there folks,

Can anyone tell me what the conversion code is to get the number of the week in a year corresponding to a supplied internal date using OCONV ?

Thats ok buddy. Glad you got it resolved. Just mark it as resolved and have a cup of tea, or coffee :wink: Thanks DSguru ...... I guess sometimes one has to put his problems in writing to realize he's already got the solution or that there was no problem at all in the first place !! :o Guess I had ...

Crap !!

I feel like a complete idiot !!

Ur right, I have already found the solution.

What was I thinking.....

Why don't I just delete this post

You pass the environment variable as a job parameter. The problem is that I have been asked to only use specific environment variables in the jobs. No job parameters. I am doing it this way because the job is going to be executed using a control file and the values for all the environment variables...

chulett wrote:So... does this need to be a Parallel job?

I am using the BASIC Transformer here because of the ease of using Iconv/Oconv functions. But I must use it in a parallel job.

I am using a BASIC Transformer in a Parallel job to generate a calendar table. The values for the start and end dates for the calendar must be obtained from a couple of environment variables. How do I go about doing this in the BASIC Transformer. Now if it was just a Transformer stage I would create...

Koti,

Search using "orchoracle". If my meory serves rite this was posted a couple days back and I guess the topic is marked resolved.

You mite want to see all the topics with Oracle stage marked "resolved"

BTW check where is your lib in LD_LIBRARY_PATH?

HTH

Cheers

The XPath on the output/columns tab has the following artist/text() artist/company/text() artist/company/price/text() so on so forth... I assume that the input/columns tab does'nt require an Xpath. Pl correct me. The xml file file format is making the output format go awry. I 'm using the TFR TRIM f...

here the fields (3,4,and 5) can have a single value or multiple values. dont know the maximum number of values for these fields.
how to do it?

Thanks

Hi Everyone, I have a file with tilda delimited(12 fields) and field3,field4,field5 can have one or multiple values separated by commas pepsi~1~1,2,3~001,002~hourly,salaried~200612~quarterly~1~U~50~peer group~pepsi report output should be: pepsi,1,1,001,hourly,200612,quarterly,1,U,50,peer group,peps...

Hi Ray

The problem is even through i figured rob is bobby in standardization, i am not allowed to change it.......but when i run thru standardization stage bob will we converted to robert., correct me if i am wrong....so is there any solution?

Thanks ray