Search results for query: *

Hi, I've searched in the informatica documentation how to calculate the Line sequential buffer length, but i've found nothing. i've configure this parameter to 4096 in my session. In my log session file i've this : FR_3071 Maximum Line sequential buffer length is 4098. i don't understand...

data are already sorted on the condition field in each joiner

Hi i've a mapping with 2 joiner, i join the first joiner with a sq and the result of the first joiner with anoter sq. Data are sorted in the two source qualifier. input sorted is check in the joiners. data are sorted on the port condition in the joiner. But i've this error : TT_11100 Fatal...

Hi, IS it possible with perl, to manage error,log like in java with "try catch". For example , if my code failed, i insert a message in a database, a message in a logfile or i launch another code. In relation to the case , i do something. Thanks for your help

thanks for your link. before posting i've see on google and find noting,about logging in oracle database. your ling talk about logging in a csv file.

Nobody can help me ?

HI, How can i do, to use log4perl for logging in table in oracle database and not in a file. is it possible ? Thanks for help

Hi all, Are you working with xml target? some one can give me some advice, tips, explain me how to use this target ? how to optimize process with xml target ? how to optimize xml writer ? thanks for your help

Hi, I'm uising DBI and i will know, how can i do , to check if the connexion failed ? I use this my $dbh = DBI->connect("dbi:Oracle:$db", $user, $pass); If my connection failed , i want to get the return code and print the connexion failed. sommething like this if ($code <> 0) then { print...

Hi all, I've a mapping use one target,and serveral sources. How can i do, to centralise all the sources in one transformation . sources come from mapplet or ohter sources with transformation. thanks.

nobody knows ???

Hi, I'va a mapping with a target xml. In informatica doc; i've read that i can load data in my target after 10000 commits for example (option "On commit" "Append to document"). Loading data after 'n' commit, is better,because we use not a lot of memory. I've select the option on commit, and...

i've no update strategy transformation, i've just my 2 sources and 2 targets. only in the session, i've precised : Data driven and for each target, if it's only "update as update" or "Insert" in the properties. If i use an update transformation , it will be run ? With an update transformation...

HI, I've a mapping which update a target A(update orverride) and insert data in another target B. In my session,i've choose the option : Data driven; For target A i choose choose : update as update For target B i choose : insert When i run the session, line are inserted in target B but noting...

Hi, I run a session and it failed without error message in the log,the log stop writing when the session failed; in the workflow log i ve this message LM_36526 : DTM process exited due to signal [6] I don't understand ? someone can help me,i am on powercenter 7.

Hi, I want to know if it possible with perl to forward an email; I want to do : connect to a mail box take the subject of the mail came today search a mail in a mailbox (if the subject is bil launch i forward the mail to anoter mailbox). if i found a mail, i forward the mail with is attachment...

thanks sxs but i don't know how many value i have in the ColC : may be 1 or 2 or 3 or 4 or ... or may be no values. May be i must use a procedure but i don't know how. Someone can help ??? show the way ??? thanks for your help

nobody knows ?

ok, i've post it in oracle forum now

Hi, I've table with this data I want to obtain this result : is-it possible to obtain a result; how can i built my query ? thanks for your help