shyamjamisetty

 Profile Answers by shyamjamisetty Questions by shyamjamisetty

• Mar 22nd, 2008

u mean only look up trf and not any other transformations? be clear? if not one senario is that , we can use multiple connected loopup trf ,depending upon the target.if u have different wh_keys in ur ...

Neha

• Apr 3rd, 2006

Use unconnected lookup if same lookup repeats multiple times.

Answer Question  Select Best Answer

Abhik

• Sep 21st, 2006

In Database parlance you can define a domain " a set of all possible permissible values for any attribute".Like you can say the domain for attribute "Credit Card No#" consists of all possible valid 16 digit numbers.Thanks.  

Ashish

• Jul 28th, 2006

Domain in Informatica means - A central Global repository (GDR) along with the registered Local repositories (LDR) to this GDR. This is possible only in PowerCenter and not PowerMart.

Answer Question  Select Best Answer

What is the impact of turning versioning on or off for an Informatica repository? What is the impact of versioning on an existing repository and the new repository, when adding a new repository to the repository server?Thanks, Deborah

adilshariff

 Profile Answers by adilshariff Questions by adilshariff

• Jul 1st, 2008

1.Versioning is a one time and one way process on Informatica repository.2.No impact on both the exisitng and new reprository.Infact Versioning is advantage,it is help full in team based  envirno...

Uma Bojja

• Aug 14th, 2007

Versioning on repository is irreversible. Once we choose to version its done.Let me know which version of informatica are you using.ThanksUma Bojja

Answer Question  Select Best Answer

svivekananda

 Profile Answers by svivekananda Questions by svivekananda

• Jul 9th, 2010

1. check in session log + monitor output if the run is successful2. open the target and check the data manually

Prasad

• Jul 14th, 2006

Hi,If you want to know the performance of a mapping at transformation level, then select the option in the session properties-> collect performance data. At the run time in the monitor you can see it ...

Answer Question  Select Best Answer

vikki_gupta2003

 Profile Answers by vikki_gupta2003 Questions by vikki_gupta2003

• Mar 14th, 2007

Hi,1)At DB level we can simply DROP the stagin table.2)then Create Target table at DB level.3) Directly LOAD the records into target table.NOTE: It is recommended to use staging area.

Prasad

• Jul 14th, 2006

hi,this question is logically not correct. staging area is just a set of intermediate tables.u can create or maintain these tables in the same database as of ur DWH or in a different DB.These tables w...

Answer Question  Select Best Answer

naga

• May 24th, 2007

In realtime star schema is the better one. Surrogate key is linked to the lowest level. For example?country, state, city, area in this surrogate key is with 'AREA'

shaik

• Jun 27th, 2006

In real time only star schema will implement because it will take less time and surrogate key will there in each and every dimension table in star schema and this surrogate key will assign as foreign key in fact table.

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

what ever is said above is correct. Just add 2 dummy ports in the joiner transformation with the same datatypes(Integer). one dummy port as detail and other as master.Then assign both the ports d...

kumar

• Jun 11th, 2006

Could you please briefly explain on this?

Answer Question  Select Best Answer

madhu

• Sep 23rd, 2006

hi nimmi please explain me regarding complete partition. I need clear picture. what tranmission it will ristrict, how it will ristric , where we have to give. thanksmadhu.

nimmi

• Aug 21st, 2006

HiIn informatica we can tune performance in 5 different levels that is at source level,target level,mapping level,session level and at network level.So to tune the performance at session level we go f...

Answer Question  Select Best Answer

what are all the modes are available for running a session.Can any one Explain in Detail?

Kishan

• Dec 6th, 2006

thq for ur reply....cud plz tell me wher we can use this stored procedure transforamtion,update strategy trnasformation with ex:..waits for ur reply 

UmaBojja

• May 26th, 2006

If u are asking about the mode in which the data is transferred then Informatica supports two modes1.ASCII2.UNICODE

Answer Question  Select Best Answer

geetham

 Profile Answers by geetham Questions by geetham

• Dec 28th, 2006

Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected a...

Motilal

• Jun 30th, 2006

Uncached lookup: The informatica server doesnot build a cache for temporary starage of data. Wenever it need to refer to the look up table, it scans the source directly.Dynamic Cache: The informaatica...

Answer Question  Select Best Answer

kjs

• Oct 13th, 2006

Constraint based loading : If your mapping contains single pipeline(flow) with morethan one target (If target tables contain Master -Child relationship) , you need to use constraint based lo...

Sivasankar

• Jul 6th, 2006

If you have only one source, it?s loading into multiple target means you have to use Constraint based loading. But the target tables should have key relationships between them.If you have multiple source qualifiers, it has to be loaded into multiple target, you have to use Target load order.

Answer Question  Select Best Answer

pavithra

• Dec 17th, 2006

Hi,Go to Session-->right click  -->Select Edit Task then Goto -->Config Object then set the property Save Session Log By --RunsSave Session Log for These Runs --->To Number of Historical Session logs you want

srisailu

 Profile Answers by srisailu Questions by srisailu

• Jul 31st, 2006

Hi,     We can do this way also. using $PMSessionlogcount(specify the number of runs of the session log to save) 

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

lingesh

• Oct 11th, 2006

Hi , Using of stored procedures plays important role.Suppose ur using oracle database where ur doing some ETL changes you may use informatica .In this every row of the table pass  should pas...

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 23rd, 2006

To execute database procedures

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 23rd, 2006

to perform dml operationsthanksmadhu

satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Aug 25th, 2006

Update Strategy is the most important transformation of all Informatica transformations.The basic thing one should understand about this is , it is essential transformation to perform DML operations o...

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 22nd, 2006

hiquestion itself there that data is quite freequently changing. Changing means it can be modify or added.Example.The best example of this one is Sales Table.

Sravan

• Sep 14th, 2006

Rapidly changing dimension is that whre the dimensions changes quikly.best example is ATM transactions(BANKS).The data being changes continuesly and concurently for each second so it is very difficult to capture this dimensions. 

Answer Question  Select Best Answer

sidhu

• Jan 25th, 2007

You cannot install informatica using the same CD that used for windows. You need to have a separate licence key for unix. Install process is quite simples , only you need to run the file called inst...

sri

• Sep 5th, 2006

you need seperate licence key for unix.I dont think windows licenese key works for UNIX.srihari_t@yahoo.com

Answer Question  Select Best Answer

informatica_buddy

• Nov 10th, 2006

You can actually create a view and import it as source in mapping ....

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 23rd, 2006

hifor database procedure we have procedure transmission. we can use that one.thanksmadhu

Answer Question  Select Best Answer

rsannu2k

 Profile Answers by rsannu2k Questions by rsannu2k

• Jun 7th, 2007

Rangini,Incremental Aggregations, I think informatica provides this feature to load the sessions which are abruptly termination in middle of the load, am I right? also I would like to know how you can...

Rangini vignesh

• Aug 30th, 2006

The above answer is slightly correct.The incremental loading is done in 3 ways by using Transformations.1.Aggregate Transformation,2.Dynamic Lookup Transformation,3.Update Strategy Transformation,In t...

Answer Question  Select Best Answer

pradeeshkumar

 Profile Answers by pradeeshkumar Questions by pradeeshkumar

• Aug 19th, 2010

It's possible to send multiple e-mails in a workflow.

WMC

• Oct 9th, 2006

Yes, only on the UNIX version of Workflow and not Windows based version.

Answer Question  Select Best Answer