satoru

 Profile Answers by satoru Questions by satoru

• Jun 10th, 2010

Power Connect is used to connect and import sources from external systemslike for example Mainframe(IMS, DB2, VSAM) or ERP or MQ Series, etc.We don't have ODBC connections to these sources and so ...

Answer Question  Select Best Answer

harikr

 Profile Answers by harikr Questions by harikr

• Dec 17th, 2009

A Mapping can be fine tuned for performance at the following levels  :1.Optimize the target. 2.Optimize the source3.Optimize the mapping4.Optimize the transformation5.Optimize the session6.O...

Answer Question  Select Best Answer

When I use the Informatica Workflow Monitor, I can see the properties by double clicking the running session task. But where is the file about the properties, because I want to read the information of the properties through some other development tools. I checked the log file, the it is not what I want. So anyone can help me to get the contents of the properties? Thank you very much~~

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jun 25th, 2007

The properties will be stored in a table of Repository data base.Please check the tables.For any further queries: sriram_kumar@oneindia.in

Answer Question  Select Best Answer

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jun 5th, 2007

The default user groups:      1) Administrators      2) Public

Answer Question  Select Best Answer

Anil Jaiswal

• Jun 21st, 2017

Using this command: sed -i $ d filename

Answer Question  Select Best Answer

Shashikumar

• Jun 21st, 2007

Data Cleansing Tool: TriliumProfile tool: Informatica Profiler

Answer Question  Select Best Answer

madarapu

 Profile Answers by madarapu Questions by madarapu

• Jul 3rd, 2007

Yes we can if the soure and target is from same type of database then we can use a same odbc(dsn) for both of them.

Answer Question  Select Best Answer

Hi All,
I have oracle data source table and flat file target, now I want load data from oracle table source to flat file? How can I do? Which tranformation needs to this one? Please give solution with steps.

Thanks in advance.

lakshmi

• May 27th, 2012

Source--->sqt/r--->Target
In session level(advanced file properties) u have to set some of the properties like output type,directory, filename and codepage type.

Answer Question  Select Best Answer

Deepak Rajkumar

 Profile Answers by Deepak Rajkumar Questions by Deepak Rajkumar

• Feb 18th, 2008

Using Normalizer, in the normalizer properties we can add coloumns and for a coloumn we can specify the occurance levels, which converts rows into coloumns.

Answer Question  Select Best Answer

KB

• Jul 26th, 2007

If you want to save and reuse the cache files, you can configure the transformation to use a persistent cache. Use this feature when you know the lookup table does not change between session runs. Usi...

Answer Question  Select Best Answer

I want to start a workflow from one server to another server. It means,upto now In UNIX Server i have all the scripts and in the same server only we are storing the Infomatica Repositories, hence to start that workflow iam using "pmcmd" command. Now i am getting a situation where this Repositories will reside in another server. Now Basis on that i want Built a script. Can any one Help me. Get back...

sriluck

 Profile Answers by sriluck Questions by sriluck

• Sep 25th, 2007

I came acrross a similar situation in my project.The scenario was:my script consisted of calling the informatica sessions and calling ora_sql functions to run sql scripts.Informatica was  recidin...

Answer Question  Select Best Answer

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