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

Code Page is used to identify characters that might be in different languages. If you are importing Japanese data into mapping, u must select the Japanese code page of source data.

reshhhhhh

 Profile Answers by reshhhhhh Questions by reshhhhhh

• Sep 23rd, 2010

The code page influences the way the application stores, recieves and sends the data. Code page is basically to convert any language to the language that the system understands.

Answer Question  Select Best Answer

Two methods 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation. Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time. If u change the properties of a reusable transformation in...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

You can design using 2 methodsusing transformation developercreate normal one and promote it to reusable CheersSithu

Praveen Vasudev

• Sep 12th, 2005

PLEASE THINK TWICE BEFORE YOU POST AN ANSWER.Answer: Two methods 1.Design it in the transformation developer. by default its a reusable transform.2.Promote a standard transformation from the mapping d...

Answer Question  Select Best Answer

During the session ,the informatica server compares an inout row with rows in the datacache.If the input row out-ranks a stored row,the informatica server replaces the stored row with the input row.The informatica server stores group information in an index cache and row data in a data cache.

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Apr 11th, 2014

Rank caches are the caches created to calculate the rank while session run for Rank transformation. Index cache and Data cache Index cache stores the values of the key column i.e. rank port here. D...

Answer Question  Select Best Answer