Search results for query: *

You can find the "Run if previous completed" in session properties in v5.1. Just edit the session and click on log&error handling tab. than check the radio button Run if previous completed. this will solve your purpose. Let me know if you are still not clear. Thanks Ajay

Hi, When you copied the mapping into other folder,it will have the mapplets assoicated with it.When you import the mapping the mapplet also got imported. So when you are trying to import another mapping with same mapplet this message will appear i.e Rename,reuse or skip. just select reuse. this...

Hi, Configure the batch to run sequential.than you will get the previous functionality. -Ajay

Hi, Fatal error generally occurs if unable to load data into target. following may be the reason for this occurence. 1. The source data type and target data type does not match. 2. the source data type and target data type are not compatible like BLOB data type etc. check the actual data type...

Hi, This can be done using 2 flows in the same mappings. suppose x is flat file and ta and tb are the 2 targets. assume ta1 and ta2 are the 2 instances of ta target and tb1 and tb2 are the 2 instances of tb target. so create 2 workflows in mapping as follows: 1 st flow...

Hi, Actually I am working on 5.1 so no idea of abt workflow but if u are saying u want to schedule the no. of batches in folder and for each batch u are specifying the schedule time. Instead of that you want this to be done at only once or single file. if this is your requirement what i suggest...

Hi, I never used this utility but please check following: 1.Are u giving this command on the same server on which the server is installed? 2.Check the directory where u are firing this command. The directory shoule be informatica server directory. 3.see the log file for error. Try all these...

Hi, Informatica doesn't support CLOB data type. Even if you change the data type in source it doesn't work since informatica is unable to read CLOB data type. So you need to change the CLOB data type at source atleast. -Ajay

Yes u can schedule jobs using Informatica Server manager but if u do not like to use this way also u can use cron utility of Unix to schedule the Batches/Sessions. For this u need to use PMCMD command to be given in the unix shell scripts which crontab is going to call. -Ajay

1. Elaborate more. 2. When the Mapping is invalid, see the window at bottom, that will show the reason for Invalid and accordingly rectify the Mapping. 3. There are 2 ways of doing this if source or target tables changes. a) You can manually change the source tables structure and target...

Hi Sanjay, The indicator files are generated for event based Scheduling. Its Zero byte file created on Unix. Once the session reads this files its get deleted. You can use command touch <Indicator_file_Name> at presession or post session script. Indicator files are used when u want...

In designer you will have three repositories, one for developement i.e Dev_rep, one for testing i.e test_rep and pproduction repository i.e prod_rep.After developement you can move that folder to test repository. After User accepatance testing that is moved to production repository. If the...

If you can avoid using fact table as a lookup table it will give u better performance. It also always unadvisable to use fact table as a lookup. -Ajay

If you want the file name to be in error database table what you can do is pass the name of the file as a parameter to mapping. use this parameter to populate the error database table. -Ajay

If your informatica is running on Unix box you can simply write the Unix cmd in post session script option in session properties tab. for example: cp source_file.txt source_file.bak This can be specified in post session if you want to rename a file which has been loaded successfully in...

You need to specify the name of the file in session properties that need to be loaded into warehouse. Once the data is loaded into warehouse successfully rename that file to .bal extension or .old. this can be done in post session script. So that it will be easy to differentiate between old and...

Trying the repository tables to get the start time of the first session will do the trick. See if this is feasible with your requirement.

1. You can handle rejected rows by looking at bad file which gets created if records are rejected. you can correct the records in reject file and then can load again. 2. Email notification can be send using the post session tab of the session. You need to just specify the email address and...

Have you specified delimiter at session level? If not specify the delimiter and check. If you still face problem let me know.

Once you define the ODBC for microsoft excel import the excel sheet. To import excel sheet open the source analyser and click on Import from the database. Than select the ODBC source name and enter userid and password. You will get list of tables in left pane. select and press Ok. Once u create...