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

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 22nd, 2006

Hi,Name itself it is saying that agent means meadiator between and repositary server and reposatary database tables. simply reposatary agent means who speaks with reposatary.thanksmadhu

chsrgeekI

 Profile Answers by chsrgeekI Questions by chsrgeekI

• Sep 13th, 2006

Hi,   The Repository Server uses a process called Repository agent to access the tables from Repository database.The Repository sever uses multiple repository agent processes to manage multiple repositories on different machines on the network using native drivers. chsrgeekI

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 22nd, 2006

himapping is nothing but flow or work. where the data is coming and where data is going. for this we needmapping namesource tabletarget tablesession.thanksmadhu

sperumandla

 Profile Answers by sperumandla Questions by sperumandla

• Sep 21st, 2006

Please let me know the answer for this question.

Answer Question  Select Best Answer

manojkumarkurnool

 Profile Answers by manojkumarkurnool Questions by manojkumarkurnool

• Feb 13th, 2008

flatfile is only a permanent store age device means it flow only read processbut dynamic cache is used for read and wirte process so  in a flat file u cannot use a dynamic cache in flatfiles

chandrarekha

 Profile Answers by chandrarekha Questions by chandrarekha

• Feb 6th, 2008

You can use dynamic chache in flat files with new versions after 7.1.1

Answer Question  Select Best Answer

superhero

 Profile Answers by superhero Questions by superhero

• Dec 12th, 2008

Take two normalizer transformation,pass 1to 81 colomns to N1,81-200 N2.then do the operations in normalizers what ever you want and pass the records from n1- t1 and n2 -t2.

Sharad

• Jan 17th, 2007

Createa a temp stage table, load all the columns in it. The extract all columne from staging table and populate both tgt tables as you want.Cheers.Sharad

Answer Question  Select Best Answer

sri

• Dec 28th, 2006

Hi srinu,Can u explain how to "associate sequence"?Thanks,Sri.

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

When we selecting the dynamic  cache in look up transformation the informatica server create the new look up row port,  it will indicates the numeric value wheather the informatica server in...

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 11th, 2012

When an Aggregator transformation is used without sorter, it stores all the data before performing the grouping operation. But when a sorter is used before aggregator, it sorts all the data before pas...

sai

• Feb 14th, 2007

passing data to sorter is time taking why because sorter transf stores whole data in buffer and then sorts based in specified ports.insted of passing data to sorter transf ,sort d data in the sours...

Answer Question  Select Best Answer

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• May 11th, 2010

There are multiple ways to do it src-->seq gen --> trans --> tgtUse a seq gen to get transaction id1) Filter TransUse filter to filter in transaction id<=102) RouterRoute transaction id<...

afzal

• Nov 3rd, 2006

hi,For falt file sourecsource--sq--sequence generator tran.on new fileld id--filter tran. id<=10--traget

Answer Question  Select Best Answer

sivaprasad

• Nov 7th, 2006

in informatica7.11. we can take flatfile as a target 2.flatfile as lookup table3.dataprofiling&versioning4.union transformation.it works like union all.thanks &regardssivaprasad

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Nov 6th, 2006

load manager is a manager who will take care about the loading process from source to target

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 24th, 2006

After creating the mapping each mapping can be tested by the developer individualy

raja147

 Profile Answers by raja147 Questions by raja147

• Nov 21st, 2006

Hiutps are done to check the mappings are done according to given business rules.utp is the (unit test plan ) done by deveploper.

Answer Question  Select Best Answer