top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration
Print Preview

How to create the error file and rejected file while running the work flow

+1 vote
86 views

If work flow run on informatica level how to create the automatically file create error records and rejected records in one file.

posted Aug 28, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

Double click on Session -> Config Object -> Error Handling -> Error Log Type -> Flat File -> File Path & Name.

answer Apr 24, 2014 by Shatark Bajpai
Similar Questions
+2 votes

If work flow run on informatica level how to create the automatically file create error reocrds and rejected records in one file.

+1 vote

I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target table has the the incoming rows from the source or not. I have set for the Update transform a condition

IIF(ISNULL(target_table_surrogate_id), DD_INSERT, DD_REJECT)

Now, when the incoming row is already in the target table, the row is rejected. Informatica writes these rejected rows into a .bad file. How to prevent this? Is there a way to determine that the rejected rows are not written into a .bad file? Or should I use e.g. a router insted of an update transform to determine if the row is insert row an then discard the other rows?

+1 vote

While Installing Informatica i am getting this ERROR....

The command to create the domain failed. Select OK to correct the domain information and try the command again. Select Continue to continue the installation without creating the domain. You can run the command to create the domain after installation. Review the log files for more information.

Informatica_9.0.1_Services_HotFix2.log [LOG FILES SAY'S]
Domain name: : Domain_SONY 
Node host name: : SONY 
Node name: : node01_SONY 
Node port number: : 6005 
NODE_ADDRESS : SONY:6005
LOGS_DIRECTORY : C:\Informatica\9.0.1\isp\logs 
BACKUP_DIRECTORY : C:\Informatica\9.0.1\server\infa_shared\Backup 
DOMAIN_USER : Administrator 
  DOMAIN_PSSWD : ***** 
    NODEOPTIONS_XML : C:\Informatica\9.0.1\isp\bin\nodeoptions.xml 

 Exit Code : -1 

OutPut : [ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002} Cannot create domain, operation failed with error: [INFASETUP_10000] C:\Informatica\9.0.1\tomcat\conf\server.xml (The system cannot find the file specified).]. Error :

 I Think i need to fix server.xml file but HOW?  

ANY HELP WOULD BE APPRECIATED..


Useful Links with Similar Problem
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#470/147, 3rd Floor, 5th Main,
HSR Layout Sector 7,
Bangalore - 560102,
Karnataka INDIA.
QUERY HOME
...