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

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

*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

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

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

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

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

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

Master thread: Creates and manages all other threads Maping thread: One maping thread will be creates for each session.Fectchs session and maping information. Pre and post session threads: This will be created to perform pre and post session operations. Reader thread: One thread will be created for each partition of a source.It reads data from source. Writer thread: It will be created to load data...

Killer

• Oct 12th, 2006

Yupz this make sense ! =)

Answer Question  Select Best Answer

zskhan

 Profile Answers by zskhan Questions by zskhan

• Oct 12th, 2006

1. v7 has repository server & pmserver, v5 had pmserver only. pmserver does not directly talks to repository database, it talks to repository server which in turn talks to database.

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

Anonymous

• Oct 13th, 2006

During the logical design phase, you defined a model for your data warehouse consisting of entities, attributes, and relationships. The entities are linked together using relationships. During the phy...

Answer Question  Select Best Answer

kareem

• Oct 16th, 2006

Presistent cache stored in the server folder

Vamsi Krishna.K

• Oct 1st, 2006

The informatica server saves the cache files for every session and reuses it for next session, by that the query on the table will be reduced, so that there will be some performance increment will be there.

Answer Question  Select Best Answer

Sakthivel

• Oct 17th, 2006

Thank you very much Subbarao..

subbarao.g

• Oct 16th, 2006

There are two types of flate files:1.Delimtedwidth2.Fixdwidth

Answer Question  Select Best Answer

ravi guturi

• Oct 17th, 2006

Main advantage in starschema1)it supports drilling and drill down options2)fewer tables3)less databaseIn snowflake schema1)degrade query peformance because more joins is there2)savings small storage spaces

srinivas.vadlakonda

• Oct 16th, 2006

Schemas are two types starflake and snowsflake schema, In starflake fact table is in normalized format and dimention table is in denormalized formatIn snowsflake both fact and dimention tables are in ...

Answer Question  Select Best Answer

ssatishreddy

 Profile Answers by ssatishreddy Questions by ssatishreddy

• Oct 18th, 2006

give me the answer please

lakshmi1

• Oct 16th, 2006

HiWe can not use joiner when:1) both pipelines come from the same source2) both pipelines come from the same normalizer3)If one pipeline contain an update strategy or a sequence generator ( connected/unconnected )Regardslakshmi

Answer Question  Select Best Answer

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

Like java, informatica is a plat-form independent, portable and architechtural nutral.

Answer Question  Select Best Answer

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

Using flat files sql override willnot work. the extension of the flat files are .txt,.doc,.dat and the output or target flatfile extension is .out

Rajesh

• Oct 10th, 2006

In Flat file SQL Override will not work. We have different properties to set for a flat file. If you are talking about the flat file as a source it can be of any extension like .dat,.doc etc. Yes if i...

Answer Question  Select Best Answer

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

Using source analyzer and warehouse designer

Answer Question  Select Best Answer