What is the difference between informatica7.1 and new version 8.1,what are the advantages in new version 8.1.

Ramakrishna Rao Vaka

• Oct 12th, 2006

Hi,The new Version Informatica 8.1 has got some additional feature's like:1) Mapping Generation Option2) Push Down Optimisation3) Data Cleanse and Match4) Data Federation (EII)5) Enterprise Grid6) Hig...

Answer Question  Select Best Answer

Myk

• Oct 11th, 2006

Are you lookuping flat file or database table? Generaly, sorted joiner is more efective on flat files than lookup, because sorted joiner uses merge join and cashes less rows. Lookup cashes always whol...

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

srinivas vadlakonda

• Oct 11th, 2006

in 7.x it have the more feature compare to 6.x liketransaction cotrol transformationunion transformationmidstream XML transformationflat file lookupcustom transformation function likesoundex,metaphone

raj

• Aug 2nd, 2006

Hi, Tell me some architectural difference between the two.

Answer Question  Select Best Answer

srinivas vadlakonda

• Oct 11th, 2006

key range: The informatica server distributes the rows of data based on the st of ports that u specify as the partition key.Round robin: The informatica server distributes the equal no of rows for each and every partition. 

Answer Question  Select Best Answer

*Advanced External procedure transformation and External procedure transformation: This Transformation contains a check box on the properties tab to allow partitioning.*Aggregator Transformation: If you use sorted ports you cannot partition the associated source*Joiner Transformation: you can not partition the master source for a joiner transformation*Normalizer Transformation *XML targets.

srinivas vadlakonda

• Oct 11th, 2006

Advanced External procedure transformation and External procedure transformation: This Transformation contains a check box on the properties tab to allow partitioning.Aggregator Transformation: If you...

Manasa

• Sep 7th, 2006

1)source defination
2)Sequence Generator
3)Unconnected Transformation
4)Xml Target defination

Answer Question  Select Best Answer

Kapil

• Oct 11th, 2006

Hi Flat files have some advantages which normal table does not have. First one is explained by first post. Secondly, Flat file can work with case sensitivity issue of data easily., where normal table has errors.Kapil Goyal

opbang

 Profile Answers by opbang Questions by opbang

• Oct 5th, 2006

Loading data from flatfiles to database is faster. You are receiving a data from a remote location. At remote location the required data can be converted into flatfile and same you can use at target location for loading. This minimizes the requirement of bandwidth, faster transmission.

Answer Question  Select Best Answer

srinivas vadlakonda

• Oct 11th, 2006

transaction can occur without the measure fore example victim id

opbang

 Profile Answers by opbang Questions by opbang

• Oct 4th, 2006

Factless Fact table are fact table, which is not having any measures.  For example  - You want to store the attendance information of the student.  This table will give you datewise, wh...

Answer Question  Select Best Answer

Where exactly dimension and fact tables are useful? Is it source or target?We are importing source directly from database and transforming and loading the data to target.Can anybody please send where they exactly it is useful?

rajani

• Oct 10th, 2006

Can you explain with some examples?Thanks.

samba

• Aug 22nd, 2006

Dimesions and fact tables are nothing but tablesDimesions and facts are targets for the mappingsfirst u have to load the data into dimensions these are called master tables after that by using transac...

Answer Question  Select Best Answer

sravangopisetty

• Oct 10th, 2006

Ading to the point it also increase the no of rows in target.Example if the condition is given as sal

pushpa

• Oct 3rd, 2006

An active transformation can change the number of rows that pass through it.In Router you have the default group .If you want we can drop all rows in the default group, by not connecting it ...

Answer Question  Select Best Answer

sravangopisetty

• Oct 10th, 2006

Types of dataflows1.sequential execution.2.paralal execution3.control flow execution

Answer Question  Select Best Answer

lingesh

• Oct 5th, 2006

Yaa we can refresh materialized view. While creating of materialized views we can give options such as refresh fast and we can mention time so that it can refresh automatically and fetch new data...

Answer Question  Select Best Answer

balaji

• Oct 5th, 2006

Hai,COM is technology developed by Microsoft  which is based on  OO Design .COM Componenets exposes its interfaces  at  interface pointer  where client access Components ...

Answer Question  Select Best Answer

Raj

• Oct 5th, 2006

its depends for client requirements.initially we have implement?high level design?.so,the client want to be normalized (snow flake schema) or de-normaliized data (star schema) which is used for their analysis.so we have implemented whatever their requirements

Answer Question  Select Best Answer

anand

• Oct 4th, 2006

definatly

Answer Question  Select Best Answer

Vamsi Krishna K.

• Oct 3rd, 2006

Shortcut is a facility providing by informatica to share metadata objects across folders without copying the objects to every folder.we can create shortcuts for Source definitions Reusable transformat...

Answer Question  Select Best Answer

Vamsi Krishna.K

• Oct 1st, 2006

if you selected commit type is target, once the cache is holding some 10000 records server will commit the records, here server will be least bother of the number of source records processed. if you s...

srinivas vadlakonda

• Sep 29th, 2006

Commits the data based on the course records

Answer Question  Select Best Answer

Vamsi Krishna.K

• Oct 1st, 2006

hello,we have to update target table. if you are loading type-1 dimension,type-2 dimension data at target surly you have to do. this update can be done by two type.1. using update stratergy2. target update override.Thanks,vamsi.

Answer Question  Select Best Answer