-
What r the circumstances that infromatica server results an unreciverable session?
The source qualifier transformation does not use sorted ports. If u change the partition information after the initial session fails. Perform recovery is disabled in the informatica server configuration. If the sources or targets changes after initial session fails. If the maping consists of sequence generator or normalizer transformation. If a concuurent batche contains multiple failed sessions.
-
How to pull the data
Hi,How to pull the data from XML and flat files in informatica?How to pull the data from Materialized view in informatica?
-
Replace special characters
If you have column name as f_name in which the data is "john&","97edward","do__nna" . you want to remove/replace the special characters and then send the output as "john","edward","donna" to the target. what is the transformation and what is the function to be used in the mapping(informatica)
-
-
Informatica job via UNIX script problem
I am getting following error when i tried to run Informatica job through a UNIX script.The error is ERROR: Invalid user name or password.WARNING: Lost server connection.The user name and password is correctly entered and there is no discrepancy regarding that.The Unix log file says2007 OPALD31_LOAD_PLINK_ANNUALSTATEMENT.ksh FATAL ERROR - Session Failed, batch w_m_OPAL_PLINK_Annual Statement_load_to_stage,...
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Informatica Interview Questions
Ans