Hey everyone,
Quick question, has anyone run into any issues doing multiple lookups against the same table in the same mapping? I'm a bit worried about deadlocking the table and the mapping not working. I was handed a badly data modeled dimension table and have no choice but to deal with it...
Hey everyone,
I just got a "new" work laptop from my company and it has an Ati Radeon 9600 chipset and runs Windows 2000 pro. I'd like to be able to run two monitors on this thing but as an expansion of the laptop's LCD, not merely a extra presenation screen.
I downloaded Hydravision from...
Thanks for the information flugh! Would I need to look in some sort of config file for this "Options" directive? I'm on a shared web hosting service, so I'm kind of learning how to get around through Cpanel. If I knew what file needed to be edited (if any) I'd have a better idea of where to...
sedj and thedaver,
The files in question are website html files and graphics used in the website. The problem is that when someone simply types in the directory name (i.e. www.mywebsite/subfolder) they see a listing of the webpage filenames or graphics. I'm just trying to keep that from...
Hey everyone,
I have a website hosted on a linux server and I'm trying to figure out the proper permissions for subfolders within my public_html folder. Website visitors can get into my subfolders and peruse files via that parent directory structure page and I'd like to put a stop to it. Can...
Ok so I'm trying to do another funny thing now in Informatica =)
I have a lookup with a SQL override statement already written and working. Now I need a little more flexibility in terms of being able to dynamically adjust that override statement. Basically what I need to do is this...the last...
Hey everyone,
Quick question regarding shortcuts...I know that if you made adjustments to the original object, the shortcuts linked to that object will pick up the changes accordingly. In the case of a target relational table, what if I were to delete that object and re-import the table with...
DRJ478's suggestion would probably work well. Yeah I could use an array, just thought there'd be a function something as useful as this though. I was thinking along the lines of DR's function anyway...thanks everyone for their suggestions!
I just realized why I'm getting this problem, first argument is a julian DAY, not month. I could just drive my head through my desk right now =/ lol. Does anyone know if there's a proper function that will take a month number and give me the corresponding month name?
That's strange because when I tossed in a "0" and echoed, it didn't print out anything in the html. Looks like I'm going to have to use a case statement for this. How annoying =P
Finally figured it out early this morning. I used this way:
[code]
select * from schema.table where table.TS_LOAD > TIMESTAMP('20051122000000');
{/code]
Thanks for the help!
Ok so I might be going a little nuts here...
I'm using jdmonthname($var,0) to pick up the abbreviated month names like "Jan", "Feb", etc. Here's the problem:
I feed it the number 11 for the first argument and I end up getting "Dec"(?!). It's very strange...I replaced that variable with a 2...
Hey everyone,
This is probably a very easy question but for the life of me I can't find any examples to get me past this. Here is my query:
Select * from schema.table where schema.table.TS_LOAD > TIMESTAMP('2005-11-22');
When executing, I get an error back that says:
[IBM][CLI...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.