Search results for query: *

I think You can install the two version of Informatica but in different folder and at one point of time you can start only one version i.e either 4.7.3 or 6.1. HTH Raj Arora

Prodev, You can use post session command to update the flag,that way u will be sure if any error happens in the session the post session command will not run . HTH Rajesh

If Paradox support ODB, than you can create an ODBC connection and fetch the record. HTH Rajesh

Rohan, I would do it in this way,In the lookup(connected),put the default value and then Put an expression transformation and sequence generator after lookup(connected), and in the expression transformation check for default value and if it is there then insert the sequence.

Prodev, If u want to delete all the records before loading, use truncate option od session properties instead of writing the Pre/post SQL. HTH Rajesh

try to put ther tracing level to Verbose data and than run the workflow, may be u can get more infor, or try to peep into event viewer there u might get some hints. Rajesh

ritanya , Plz go throgh the lookup transformation of Informatica guide, u will find it best ,if after reading that u have any doubt, that can be posted. Rajesh Arora

Hello Harlak13, to use an Order by in the source qualifier override is more efficient than using sorter transformation,remember whatever operation u can peroform on db side is always more efficient than doing using informatica transformation. HTH Rajesh Arora

No, not really but yes it is recommended to use it before aggregator transformation.

You can implement the slowly changing dimension type where you can maintain the history, this is for Data warehouse system.

Hello Group, I am looking for the comparison of Informatica with Hyperion product,if any of you can throw some light on this, I will be grateful. Thanks in advance Rajesh

Hello , I have been using SQ transformation,and I know it is a trnasformation which has to have in mapping even in simple pass through mappings,but question is why it is required,is it b'cos Informatica wanted it ?? Rajesh [bigears]

Hi Gurus, Can any one tell me the difference between the Informatica and oracle sequence Generator. Thanks in advance Raj Arora

I got this solved, actually my .mdb file was not on Informatica server m/c, i think it is supposed to be at Informatica server.

Hello, I am trying to read the data from the MS Access Table in Informatica version 5.1,but my session fails and gives the error LMN_1046,In the DataBase connection, I have key in the foollowing parameter and I have a doubt on one parameter which seems to be causing this issue, The following...

What is radiant transformation or I am misspelling it by chance. Thanks Raj

what is the confirmed dimension and fact table ?

Hello, I want to Implement Incremental Loading from the Source to target, on per day basis, as the current source DB Table does not have any flag like update_date ,so should I create an extra coulmn in the target table and do the look up . Please suggest the best way to implement this with...

Hi Sri, Thanks for your clarification, Actually I do have version 5.1 not 5, so i did try to write to a flat file and it worked. As I am new to DWH and now a days learning Inforamtica on my own, so sometime I might ask foolish questions also, Please bear with me. One more thing which got...

Sri, Can u please elaborate me of creating the text file as target on version 5.0, as I tried to explore on Informatica version 5.0, but could not find. Raj