shiva

• Oct 30th, 2006

mostly we are geting oracle fatal error.whilw the server is not able to connect the oracle server.

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

anjanroy

 Profile Answers by anjanroy Questions by anjanroy

• Sep 12th, 2007

Datawarehousing projects are different from the traditional OLTP project. First of all they are ongoing. A datawarehouse project is never "complete". Here most of the time the business users...

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

sravangopisetty

• Oct 10th, 2006

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

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

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

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

subhrajyoti brahma

• Oct 20th, 2006

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

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

Acrien

• Nov 3rd, 2006

Informatica Sequence Generator:Maximum value reached at 2^(31) or 2.147 billion, and will automatically restart at 0. The sequence generator will calculate the max value in the column that you're add...

Answer Question  Select Best Answer

n k rajkumar

• Nov 2nd, 2006

User Defined Transformations Are Stored Procedure and Sourcr Qualifier 

Answer Question  Select Best Answer

How many star schemas can you use in a project? Is it possible to use more one star schemas?

thirupalankireddy

 Profile Answers by thirupalankireddy Questions by thirupalankireddy

• Sep 12th, 2010

Yes, there can be any number of star schemas.

Answer Question  Select Best Answer

Is metadata repository informatica a file format or database format?

thirupalankireddy

 Profile Answers by thirupalankireddy Questions by thirupalankireddy

• Sep 12th, 2010

Metadata repository exists in the form of databases

Answer Question  Select Best Answer

How to load time dimension using Informatica?

laltho

 Profile Answers by laltho Questions by laltho

• Aug 29th, 2010

My understanding is time dimension can be loaded by using stored procedure, No live project experience, got info from reading material.

Answer Question  Select Best Answer

How to check whether rows existed in target or not by using joiner?

surinr

 Profile Answers by surinr Questions by surinr

• Mar 18th, 2011

Use a lookup transformation and compare the target record with source record for existence of the record in the target table.

Answer Question  Select Best Answer

On one day there are 10 cities and the other day 5 more cities gets added? then how do you change the transformation? What do you do?

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

If there is change in the data, there is no need to go for changing of the transformation. Instead you can insert/update the incremental data.
Please elaborate the question if not answered.

Answer Question  Select Best Answer

Compatibility between code pages is used for accurate data movement when the Informatica Sever runs in the Unicode data movement mode. If the code pages are identical, then there will not be any data loss. One code page can be a subset or superset of another. For accurate data movement, the target code page must be a superset of the source code page.Superset - A code page is a superset of another...

Within a session. When you configure a session, you can instruct the Informatica Server to either treat all records in the same way (for example, treat all records as inserts), or use instructions coded into the session mapping to flag records for different database operations. Within a mapping. Within a mapping, you use the Update Strategy transformation to flag records for insert, delete, update,...

U can use command line arguments for a session or batch.This allows U to change the values of session parameters,and mapping parameters and maping variables. Parallel data processing: This feature is available for powercenter only.If we use the informatica server on a SMP system,U can use multiple CPU’s to process a session concurently. Process session data using threads: Informatica server runs the...