Rambabu.Gali

• Nov 27th, 2007

Instead of creating multiple cache files informatica server creates only one cache file for all the lookups used with in the mapping which selected as a shared cache option.

chandrarekha

• Sep 28th, 2007

If you are using single lookup and you are using only for reading tha data you can use satatic cache

Answer Question  Select Best Answer

swaphoney

• Nov 26th, 2007

You can achive this by using the reusable tranformation wizard, or can be achived by marking the already created tranformation as reusable 

Answer Question  Select Best Answer

kalyan

• Nov 22nd, 2007

SQL Override is used to restrict the number of row returned from source by adding where cluase or user defined join??

SRIRAM N

• May 9th, 2007

Lookup SQL query over ride can be used when you want to look up values from ?more than one table.sriram_kumar @ oneindia . in

Answer Question  Select Best Answer

Nick

• Nov 20th, 2007

INF Basic Data flow means Extraction, Transformation and Loading of data from Source to the target.CheersNick

Answer Question  Select Best Answer

ramesh raju

• Nov 20th, 2007

Reusable transformation is a single transformatin, which can be resuable & mapplet is a set of transformations which can be reusable.

Answer Question  Select Best Answer

naresh

• Nov 19th, 2007

It is not possible to change the target table dynamically. According to me, we can change the connection of the table dynamically by changing the session properties.

Answer Question  Select Best Answer

(connected & un connected)

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Nov 17th, 2007

Look up transformation compares the soure with specified target table,and forwarded the records to next tranformation only matched records.If not match,it returns NULL

Answer Question  Select Best Answer

Hi guys,I have a question why my Informatica PowerCenter Workflow Manager does not show the repository anymore. I can't connect it because the screen is totally blank. The connect and disconnect tools can't be clicked. The only thing i can click is Add. So, how can i make it work again? This suddenly happens like that.

priyagambhir

 Profile Answers by priyagambhir Questions by priyagambhir

• Nov 15th, 2007

Its very simpleGoto View Menu OptionSelect Navigator..it will start showing the repository windowregards

vijay_00891

 Profile Answers by vijay_00891 Questions by vijay_00891

• Apr 16th, 2007

When u create a repository it must showup in Workflow manager Or else u can add a Repository by clicking the add button in workflow manager then u will be asked for repository name and username. Type ...

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Nov 14th, 2007

Pre-session:Before executing session, this pre-session command executesPost-session:After the completion of execution of this session, the script in the post-session runs.

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Nov 14th, 2007

You can use the Repository Manager to perform the following tasks:Add or remove a repository.Work with repository connections. Search for repository objects or keywords.View object dependencies. Compa...

obli prabu KV

• Oct 28th, 2007

Using repository manager*We can create folders under the repository*Create Sub Folders and Folder Management*Create Users and USer Groups*Set Security/Access Privilges to the usersand many more... 

Answer Question  Select Best Answer

U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier transformation.Where as u doesn’t need matching keys to join two sources. Two relational sources should come from same datasource in sourcequalifier.U can join relatinal sources which r coming from diffrent...

divakar

• Nov 5th, 2007

source qualifier is used for reading the data from the database where as joiner transformation is used for joining two data tables.source qualifier can also be used to join two tables but the conditio...

pkonakalla

 Profile Answers by pkonakalla Questions by pkonakalla

• May 23rd, 2007

hi, as per my knowledge, you need matching keys to join two relational sources both in Source qualifier as well as in Joiner transformation. But the difference is that in Source qualifier, both the keys must have primary key - foreign key relation, Whereas in Joiner transformation its not needed.

Answer Question  Select Best Answer

I have a requirement to lookup the same table twice with different keys one after another. If the first lookup fails then only the second lookup should be done. And, i have to use connected lookup to return multiple output ports. Any idea how to do?

mahindra

• Oct 31st, 2007

Hi,The solution provided is correct. I would like to add more information into it.Reusable Sequence Generator is a must for a Mapplet:Mapplet is basically to reuse a mapping as such if a non- reusable...

PHILIP

• Jun 11th, 2007

Hi Question is, Are you sure its going to start with the 1000 number after the 999. By default for reusable SEQUENCE, it has a cache value set to 1000, that's why it takes 1000 else if you only have 5...

Answer Question  Select Best Answer

Informatica server is in Unix environment and other server is in Windows environment. I have to connect informatica server to other server .I am taking external procedure transformation in informatica to connect both servers.Is it possible to connect both servers by using Ext. Proc. Transformation?If it is possible , how to take DLL from other server to informatica external procedure transformation?

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

sai kiran

• Oct 20th, 2007

If possible using Lookup will give better performance over joiner.Using lookup we can perform?outer joins, equi, and non equi joins.Using joiner we can perform only equi joins.In lookup we can also write SQL ovverrides.

guy.sridhar

 Profile Answers by guy.sridhar Questions by guy.sridhar

• Oct 15th, 2007

The exact difference is, by using joiner we can get both matching and unmatching records from the table .By using look up we can find out whether the records exists or not.and other thing we can ...

Answer Question  Select Best Answer

I have multiple servers, I want to assign a work flow to multiple servers

krishna

• Oct 19th, 2007

Informatica server will use Load manager process to run the workflow,load manager will do? assign the workflow process to the multiple servers.

Answer Question  Select Best Answer