Search results for query: *

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...

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...

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...

Hey everyone, This may or may not be a simple question, I'm pretty new to CSS and dabbling in it a bit. Using CSS, I created a fixed-width 2-column layout using all DIV tags and an external CSS file. The width of the entire layout is fixed, which is fine. But depending on how much material...

Hey everyone, I've been looking for a solution for this but haven't been able to find it on google. I'm attempting to insert into a varchar field a value which includes the operator plus. Meaning I'm trying to enter a value like '10+'. Problem is that mysql doesn't like it. This value is...

I'm running into a weird situation here. I'm on INFA 7.1.1, usually I can access a session's log by right-clicking on the session's name in Workflow Monitor and selecting "Get Session Log" from the menu. But on a certain session I get this error: ERROR: Cannot open log file...

Probably a simple question but just wanted to confirm with others... I include a separate php page on each of my website's pages that contains mysql_connect and mysql_select_db. Is there any security risk with this? Or since PHP is processed on the server end it doesn't matter? I'm just...

Pretty simple question. If I make a copy of a workflow in the same folder and rename it during the copy process, does it make copies of the dependent worklets, sessions, and mappings as well? Or do I have to independently make copies of those as well? Thanks, Jisoo23

Hey everyone, I'm trying to pull a file's creation timestamp so that I can do a compare with the current system date. So far I can do this: ls -l filename >| file.out file.out contains a line like this: -rw-r--r-- 1 root user 0 Oct 31 13:34 test1_103105.log So I'm trying to...

Hello everyone, Ok so I'm a literal newbie to Unix scripting (kornshell in my case) so try not to flail me too much =D I have a bunch of files that have this sort of format: test1.log test2.log test3.log I'm trying to create a script that will take those files and rename them with the...

Hey everyone, Ok so it looks like I'll be doing a patch installation for the very first time but I have some questions. Here's the current scenario: INFA 7.1.3 (SE) patch install AIX 5.2 operating system Development environment According to the instructions, it says that I can do an...

Hello all, Ok so I'm rather new to the whole collation concept. I've read the documentation on the mySQL site regarding what it does. So I have to ask, the default setting seems to be "latin1_swedish_ci" but I'm using plain English. Would I need to change all my columns to "ascii_bin"...

Hello all, I'm still learning Unix so please bear with me =) I'm sure there's a simple solution to this.... I have 3 files; file1.txt, file2.txt, file3.txt with one line of text each (respectively): header_line line1=variable line2=variable What I'm trying to do is combine all three of...

Hello all, I'm trying to figure out how I can compile a list of error message generated by recent sessions into a nice neat format...like a target table or even a text file. Specifically I'm looking to record the session name, date/timestamp, and error message that told why it failed. I...

Hello! I hope someone can help me with this. I have a session that calls a pre-session unix kornshell script. The problem is that it has trouble invoking it, I get this error message: PRE-SESS> TM_6056 Error executing shell command [/informatica/work/ksscript.ksh]. Return code is [32256]. I...

When using the Repository Manager to do a migration, I found a workflow who's session icons appear with what looks like a tiny globe on it. Does anyone know what this means? I'm new to Informatica Administration so I've never seen this before. Thanks, Glen