sriluck

 Profile Answers by sriluck Questions by sriluck

• Sep 25th, 2007

Hi Bharati,for the answer to your question, take 2 targetswith same instances T1 and T2.Lets say in T1 new records are populated.the records in T2 are checked for updation and populated accordingly.Then we can set the target load plan for updation to happen before insertion.

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jul 24th, 2007

There is no such option available to send email when scheduled off. But we can select alternate for the same.Further @ sriram_kumar @ oneindia . in

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jul 24th, 2007

First, you need to identify bottle necks, then mitigate them. then try to use options to avaoid/reduce the bottlenecks. so that you can imrove throughput.Further @ sriram_kumar @ oneindia . in

Answer Question  Select Best Answer

rasmi

 Profile Answers by rasmi Questions by rasmi

• Jul 31st, 2007

Commit interval is a interval in which the Informatica server loads the data into the target.

Answer Question  Select Best Answer

shiva4mba

 Profile Answers by shiva4mba Questions by shiva4mba

• Oct 13th, 2010

As per my knowledge the session will run successfully and the records with different datatype sizes will be skipped.This is in oracle and I am not sure about siebel.Thankx

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Aug 10th, 2007

Cache look-up uses either Static or Dynamic cachesUnchached look-up uses static caches.

Answer Question  Select Best Answer

We are planning to move from Informatica 6.1 to 8.1. I need to know the steps/guide for upgrading the repository.It is possible to go from version 6 to version 8 directly or we have to move to version 7 and then version 8

ansar

• Oct 4th, 2007

Hi Ahmed,Did you ever get the steps how to upgrade from 6.x to 8.x. If Yes please can you send it over to me, it will be of great help to me. U might receive my email but its ansaar02@yahoo.com or arshads_02@yahoo.com.Thanks a lot in Advance.RegardsAnsar.

Answer Question  Select Best Answer

chandrarekha

• Sep 24th, 2007

First column of the bad file indicates row -indicator and second column indicates column indicatorRow indicator :  Row indicator tells the writer what to do with the row of wrong dataRow indicato...

Answer Question  Select Best Answer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Sep 3rd, 2009

Using UPDATE STRATERGY, we can update the target tbale based on ket columns. To update the target table based on non-key columns, we can use the update override option in the target.

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Aug 24th, 2007

By default there will be no name for the cache in lookup transformation.  Everytime you run the session, the cache will be rebuilt.  If you give a name to it, it is called Persistent Ca...

Answer Question  Select Best Answer

Please give suggession. This question was asked by employer recently. Thanks in advance.

satoru

 Profile Answers by satoru Questions by satoru

• Jun 10th, 2010

In ETL- The configuration system was not enough to use informatica (too long, too many IS, to many problems to access databases, etc)- Developping new specifications : the specifications were inc...

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Aug 27th, 2007

Once you create a shortcut, you can reuse it in the folder as often as necessary.?There are two types of short cuts: LOCAL & GLOBAL

Answer Question  Select Best Answer

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 24th, 2007

The lookup table is used to split the data by comparing the source and target data. the data is branched accordingly whether to update or insert  

Answer Question  Select Best Answer

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 26th, 2007

we do. we have to update or insert a row in the target depending upon the data from the sources. so inorder to split the rows either to update or insert into the target table we use the lookup transformation in reference to target table and compared with source table.

Answer Question  Select Best Answer

deeptisa

 Profile Answers by deeptisa Questions by deeptisa

• May 2nd, 2008

The first one will be for the debugger in designer. And the other one is for the session in workflow manager.

Answer Question  Select Best Answer

venu adavelly

• Sep 17th, 2007

|| is used to concatinate two or more columns in Informaticafor exp; firstname (venu)last name (adavelly)but expecting out put is venu adavellyso we need to concatinate firstname and last name fristna...

Answer Question  Select Best Answer

vemurisasidhar

 Profile Answers by vemurisasidhar Questions by vemurisasidhar

• Sep 24th, 2007

we can do this by using mapping wizard.  there are of basically two types:1)getting started wizzard2)scdgettign started wizard is used when there is  no need to change the previous data.scd can hold the historical data.

Answer Question  Select Best Answer

anupama2000

 Profile Answers by anupama2000 Questions by anupama2000

• May 26th, 2008

Get that session to the task developer and validate it.

Answer Question  Select Best Answer

The source file is FTP'ed daily and it is appended with mmddyyyy. How do i specify the file name in the Source connection present in Informatica session

Mamatha

• Oct 24th, 2007

I hope it will work. You have to give this command in the pre session command /_`date "+%d%h%Y" | awk '{print toupper($0)}'`.txtThanksMamatha

Answer Question  Select Best Answer

sarita.harsh

 Profile Answers by sarita.harsh Questions by sarita.harsh

• Mar 2nd, 2009

BLOB and CLOB

Answer Question  Select Best Answer