sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

If the no. of records are in hundreds, one doesn't see much difference whether a static cache is used or dynamic cache.  If there are thousands of records dynamic cache kills time because it commits the database for each insert or update it makes.

srinivas vadlakonda

• Oct 17th, 2006

Specific situation is not there  to use the dynamic lookup if u r using the dynamic it will increase the performance and also it will minimize the  transformation like sequence generator.

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

Yep, Use joiner transformation to join heterogeneous sourcesDevelop the mappingIn the Session enter the respective locations or details of the sources

Vijay

• Oct 18th, 2006

Yes. It is possible having different Sources to load into the same target in a single session. But this again has a constraint on your requirement.  

Answer Question  Select Best Answer

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

If you don't have the structures, create the Source or Target structure of the XML file by going to Sources or Targets menu and selecting 'Import XML' and follow the stepsFollow the regular steps...

Answer Question  Select Best Answer

subhrajyoti brahma

• Oct 20th, 2006

The session will fail. ErrorVAR_27015: Specified parameter file not found.

Answer Question  Select Best Answer

Prasanth

• Oct 19th, 2006

Call stored procedure using a shell script.Invoke that shell script using command task with pmcmd.

Answer Question  Select Best Answer

n k rajkumar

• Oct 18th, 2006

There are two types of target load typesthey are1. bulk2. normal

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

we define target load plans in 2 ways1. in mapping2. in session

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

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

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

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

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

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

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

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

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

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

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