DSXchange

Hi Gurus I am having a scenario in which two fact tables are sharing two set of conformed dimensions. One is considered a daily fact, while the other a monthly. Can this be possible, if the dimensions are conformed. Correct me if I am wrong. Shouldnt the conformed dimensions be at the same granular...

Dimensions don't have a grain, that's a fact characteristic. Dimensions are things like customers, products, people, buildings. Things you can walk up to and kick. The Time dimension is the closest thing to having a series of grains. You could have a Year, Day, Quarter, Period, etc family of tables...

No, the 'protection' - which in this case is actually 'ReadOnly=1' - comes along for the ride during the export from a Protected Project. If you wanted to lose it, you'd have to edit the dsx before you imported it anywhere else. ps. Interesting that QA is protected but Production is not. When we fi...

djoni - That is the way it is supposed to work, once you have a "protected" status any copies of that job should also be unchangeable. I think it makes sense to do it in this fashion. Yes, it's good. I was thinking that the importing project determined the protection status of its jobs, b...

I'd like to share my new experience here. As part of my company standards, all projects in QA must be protected. And, all jobs promotion to Production server must be from QA. Turned out that the jobs carry their "protection" status when they land in the Production, though the importing Pro...

And, a sample from anyone will not help you since the db connections won't be valid at your end. Infact, what you are totally ignoring is that this is one of the most simple things to do. So just give it a try and if it doesn't work, we will walk you through it. Adjusting the db connection is easy,...

sud wrote:but YOU won't move a limb ????

whenever I request IBM support, they ask for the jobs to reproduce the problems at their installations, all types of jobs

When you have a reject link with Load, you can never remove the warning sign on the stage! The reject link is applicable for Upsert only, applicable but does not work, that's it All jokes apart, it WORKS. And yes, you are right, it is applicable only for upsert mode. Just try it, everybody uses it ...

For primary key being the same for two or more records, if you use Upsert method then you might not see rejects as the very first one will be inserted and the second and so on, will be updates. Chose load or just insert method and then you will see. I am surprised IBM said the reject does not work....

your funny sud :lol: djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible. Your query is not that hard, at all....

your funny sud :lol: djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible. Your query is not that hard, at all....

sud wrote:

DSguru2B wrote:your funny sud

haha hey djoni .. sorry, cudnt resist the temptation of cracking a joke

IBM Support said the reject link did not work!!!

The row from the input link plus an extra column called sqlcode. ... Can you please send me a small job that demonstrates a case, any simple one, where a bad input record goes to the reject link? With two input records, one bad, one good, and the Oracle table's DDL (two or three column). My email i...

I have an Oracle enterprise output stage in a job. What kind of errors in input records cause the records to go to the reject link of the stage? (the method of the stage is set to Upsert).

Thanks again Andrew. Do you happen to know any non-Java XML parser that's scalable? Can Saxxon handle large files, like 2GB? It's a Java Program so I doubt it. It tends to blow stacks at about 0.5 - 1GB even with ridiculous stack mem sizes. Why are you getting such hideous files. XML shouldn't be th...