Search results for query: *

In other words, the SQ isn't linked - it's just sitting there with the ports unconnected. No SQL can be generated because the Informatica engine doesn't know what ports/columns you want to select from the source. Link one or more columns up to a transformation and then generation/validation can...

I'm using Informatica v.5.1.1 so I'd do it using the 'Number of Sorted Ports' option that you mention in the source qualifier. This basically states the number of ports, beginning from port 1, in your source qualifier that should be sorted. So if you have: Col1 Col2 Col3 Col4 Col5 and you want...

In addition to bardhaan's posting, if you did want to keep the sessions by timestamp but only wanted to keep, say, a week's worth of logs for each session that had been run then you could build a UNIX script (if you're running on UNIX, I'd assume you could do something similar on SQL Server?) to...

Hi, does anyone know if Informatica uses connection pooling when it is connecting to a database? In other words would, say, a sqlnet.log entry for a session (connecting to an Oracle database) log a number of connection entries for the same mapping/session? Also, is there a standard number of...

For updates: ensure the target has a primary key to update on, set 'treat source rows' as update, select 'update as update' in target options. If you want to update else insert if it doesn't exist: ensure the target has PK, set 'treat source rows' as insert, select 'insert' and 'update else...

I'm not entirely sure about v6 onwards but with pre version 6, when you copy a folder from 1 repository (dev, say) to another (prod) within Repository Manager you can specify to use Advanced Options when prompted. After a few selections of dependencies and folders etc, it asks you if you want...

Hi, I'm not entirely sure of the technical and licensing aspects but you can certainly use Citrix Terminal Server to connect to Informatica. When I used it on my last project it was a matter of logging in as you would using the client straight on a PC so perhaps the same licensing rules would...