Two sources should have primary and Foreign key relation ships. Two sources should have matching data types.

Yuvaraj

• Jan 10th, 2007

Both the sources must be from same database.

Surendra

• Apr 10th, 2006

Also of you are using a lookup in your mapping and the lookup table is small then try to join that looup in Source Qualifier to improve perf.RegardsSK

Answer Question  Select Best Answer

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

hi,scd means 'slowly changing dimentions'since dimention table maintains master data ,the column values occationally changed .so dimention tables are called as scd tables and the fields in the scd ta...

srinivas

• Jan 10th, 2007

Hi,HIRE ,DIMENSIONAL DATA  IS STORED. NO  AGGRIGATE CALCULATIONS SCD WE R USING 3 WAYS1.TYPE-1: IT'S MAINTAIN CURRENT DATA ONY2.TYPE-2: IT'S MAINTAIN CURRENT DATA + COMPLET HOSTROY RECO...

Answer Question  Select Best Answer

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

Hisource data exists in OLTP systems of any form (flat file,relational database.,xml definitions.)u can acces the source data with any of the source qualifier transformationsw and normaliser tranaformation.

phani

• Jan 3rd, 2007

Hi,We get souce data in the form of excel files, flat files etc., By using source analyzer we can access the souce data

Answer Question  Select Best Answer

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

PIPELINE SPECIFIES THE FLOW OF DATA FROM SOURCE TO TARGET .PIPELINE PARTISON MEANS PARTISON THE DATA BASED ON SOME KEY VALUES AND LOAD THE DATA TO TARGET UNDER CONCURRENT MODE. WHICH INPROVES THE ...

Answer Question  Select Best Answer

manjunathda

 Profile Answers by manjunathda Questions by manjunathda

• Jan 13th, 2007

 An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, the contents of the ODS are updated...

manjunathda

• Jan 13th, 2007

An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, the contents of the ODS are updated throu...

Answer Question  Select Best Answer

tryyogi

• Jan 15th, 2007

The error codes are in Hex .You have to convert it in Decimal to have the actual error code in Unix.Googling around you would find the error code-desc pairs on some pages. This error particularly is "Not a super user" ,as far as my memory doesn't fail me.

Answer Question  Select Best Answer

lakshmi1

 Profile Answers by lakshmi1 Questions by lakshmi1

• Jan 16th, 2007

Hi,Mapplets is a group of reusable transformations. A mapplet can be called from multiple mappings.A mapping also contain reusable transformations. These transformations could be used in the same mappingRegards

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

mapping is not reusable. mapplet is reusable, mapplet is different set of transformation logic.reusable mapplets we can use in many mappnings

Answer Question  Select Best Answer

monicageller

 Profile Answers by monicageller Questions by monicageller

• Jan 19th, 2007

Hi Kiran,Can U plz tell  me in detail how do we do that?I am a fresher in informatica...plz help.thanks.

kiran

• Dec 24th, 2006

HiUse strored procedure tranformation to load time dimention

Answer Question  Select Best Answer

Ajay Kumar Mohanty

• Jan 22nd, 2007

    We are creating a session for the task through task manager

Usha

• Nov 29th, 2006

Normalizer is used to transpose columns to rows and when you are parameterizing.  Informatica power center help is great...

Answer Question  Select Best Answer

Srinivas Kumar Paga

 Profile Answers by Srinivas Kumar Paga Questions by Srinivas Kumar Paga

• Jan 23rd, 2007

Use Sorter Transformation and check "Distinct" option. It will remove the duplicates.

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

In the mapping read the flat file through a Source Definition and SQ. Apply a Sorter Transformation , in the property tab , select distinct . out put will give a sorter distinct data , hence you get r...

Answer Question  Select Best Answer

Srinivas Kumar

• Jan 22nd, 2007

I have a good example to explain this . Think about HR Data for a very big Company. The data keep on changing every minute. Now We had build a downstream system to capture a chunk of data for specific...

Sravan Kumar

• Jan 9th, 2007

Source is changing Incrementally means the data in the source is keep on changing and your capturing that changes with time stamps,keyrange and with triggers,scds.Capture these changes to load th...

Answer Question  Select Best Answer

anu

• Jan 25th, 2007

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

Answer Question  Select Best Answer

sidhu

• Jan 25th, 2007

No GUI mode for informatica in unix. In Unix you cannot design the mappings and workflow as you do in windows. Unix operating sys can only be used to run the jobs, schudule it...


Sidhu

jagadeesh

• Apr 3rd, 2006

No GUI mode in unix till now.....Only command prompt will help in unix environment for pmrep and pmcmdfrom Jagadeesh

Answer Question  Select Best Answer

sidhu

• Jan 25th, 2007

You cannot install informatica using the same CD that used for windows. You need to have a separate licence key for unix. Install process is quite simples , only you need to run the file called inst...

sri

• Sep 5th, 2006

you need seperate licence key for unix.I dont think windows licenese key works for UNIX.srihari_t@yahoo.com

Answer Question  Select Best Answer

Abhijit

• Jan 26th, 2007

Hi,In Static Cache the CACHE ON THE LOOKUP TABLE is built only once - when the 1st row enters the lookup for a comparision.During the whole session the cache stays as it was, hence the name static.In ...

Sravan Kumar

• Dec 20th, 2006

Mainly we have two caches in Lookup transfermations.1.Static cache.2.Dynamic cacheWe can use static cache as connected and Unconnected But dynamic cache is connected only.1.By using Connected Dyn...

Answer Question  Select Best Answer

Lingesh kumar

• Jan 31st, 2007

Hi, Generally any mapping is run from UNIX i..e UNIX shell script calls work flow.work flow intern calls mapping. Suppose i am generating a flat file in unix from informatica mapping,if i nee...

Answer Question  Select Best Answer

Lingesh Kumar

• Jan 31st, 2007

Hi When ever you load to source load with date timesatmp. Suppose u want ot today records into target table. So source table will have today Date timestamp for all the records which came toda...

jvivek80

• Dec 25th, 2006

Five methods for capturing data changes are available:Use source timestamps. -- Advances in operating systems and RDBMS functionality has enabled us to a large extent to identify record creation and ...

Answer Question  Select Best Answer