halgai

 Profile Answers by halgai Questions by halgai

• Oct 8th, 2007

Design a trap to a file or table by the use of a filter transformation or a router transformation. Router works well for this.

ravi kumar guturi

• Oct 5th, 2005

correction the rejected data and send to target relational tables using loadorder utility. Find out the rejected data by using column indicatior and row indicator.

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

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

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

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

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

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

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

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

(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

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

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

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

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

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

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

gdngajudn

 Profile Answers by gdngajudn Questions by gdngajudn

• Nov 29th, 2007

Execution of this query will give an error.We will get error in this Case as the the out put for table 1 is a string where as the the return of table 2 is a number and both are of different datatype.

Answer Question  Select Best Answer

what happens when a repository is deleted?If it is deleted for some time and if we want to delete it permanently?where is stored (address of the file)

sandeep_sajjan

 Profile Answers by sandeep_sajjan Questions by sandeep_sajjan

• Dec 3rd, 2007

repository is stored in database ,go  in repository admin console right click on repository then choose delete . a dialog box is displayed fill up the user name(database user wr ur repository is ...

chandrarekha

 Profile Answers by chandrarekha Questions by chandrarekha

• Nov 29th, 2007

I too want to know the answer for this questionI tried to delete the repository ,that time it was deleted after that i tried to create the repository with the same name what i was deleted earliar , it...

Answer Question  Select Best Answer

ajmani

 Profile Answers by ajmani Questions by ajmani

• Dec 5th, 2007

This can be done by a pre sql script in the session.simply go to session->mappings->target.there in presql script give truncate table tablename.

Answer Question  Select Best Answer

ajmani

 Profile Answers by ajmani Questions by ajmani

• Dec 6th, 2007

incase if only the target table name has changed ,then simply go to target designer, right click on target table name ->edit->rename it and say apply,u might not need to change in mapping design...

Answer Question  Select Best Answer