Dichen Kumar Mishra

• Feb 21st, 2007

1st u have to check the source file name,target file name that u set in Session edit being present in the unix server or not.If not present by applying the CP command:-make copy from one file to other.Regards,Dichen Kumar Mishra

Answer Question  Select Best Answer

What is the use of BUSINESS COMPONENT object ? When do we use them?

SRIRAM N

• May 9th, 2007

Business component object is used to categorise the objects.

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

Hi:Trigger can not be called from Stored procedure. Trigger will execute implicitly when u are performing DML operation on the table or view(instead of views).U can get the difference between trigger and sp anywhere in the doc.Hanu.

Answer Question  Select Best Answer

SRIRAM N

• May 17th, 2007

You can compare two mappings 1) with in one folder 2) two mappings in two differnt foldersMapping Designer --> Open folders--> MAPPING tab --> Compare then select two mappings to compare.Thats it !? Thanks it is working.

Answer Question  Select Best Answer

satoru

 Profile Answers by satoru Questions by satoru

• Jul 7th, 2010

Cube is a multidimensional representation of data. It is used for analysis purpose. A cube gives multiple views of data.

Answer Question  Select Best Answer

Navin

• Jun 2nd, 2007

With 32-bit the max memory?you can have for a session is 2^32With 64-bit?the max memory you can have 2^64 - more memory means?faster execution of sessionNavin

Answer Question  Select Best Answer

ramgan_tryst

 Profile Answers by ramgan_tryst Questions by ramgan_tryst

• May 15th, 2007

Check-In and Check-Out refers to Versioning your Mapping. It is like maintaining the changes you have made. It is like using VSS or CVS. When you right-click you mapping, you have a option called Versioning if you have got that facility enabled.

Answer Question  Select Best Answer

babu

• Jul 11th, 2007

In?above the condition satisfies is:1 satisfies A , A or B2?satisfies?B,?A or B1, 2?does not satisfies it goes to DEFAULTThere is no use of?A and B.

Answer Question  Select Best Answer

mohammed haneef

• Jun 28th, 2007

Hi,Joiner Cache will use in Joiner t/r  to improve the performance. While using joiner cache informatica server first read the data from master source and built data index & data cache in the...

Answer Question  Select Best Answer

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