Maping: It is a set of source and target definitions linked by transformation objects that define the rules for transformation. Session : It is a set of instructions that describe how and when to move data from source to targets.

Pavani

• Dec 4th, 2006

Mapping:A set of source and target definitions linked by diffrent transformation  that define the rules for data transformation. Session:A session identifies the mapping created with in the ...

Answer Question  Select Best Answer

what are all the modes are available for running a session.Can any one Explain in Detail?

Kishan

• Dec 6th, 2006

thq for ur reply....cud plz tell me wher we can use this stored procedure transforamtion,update strategy trnasformation with ex:..waits for ur reply 

UmaBojja

• May 26th, 2006

If u are asking about the mode in which the data is transferred then Informatica supports two modes1.ASCII2.UNICODE

Answer Question  Select Best Answer

Bhargavi

• Dec 6th, 2006

Can u plz explain me about time dimension.

raja147

 Profile Answers by raja147 Questions by raja147

• Dec 4th, 2006

How ? can u explain.

Answer Question  Select Best Answer

Can any one explain about the new port that is created in the lookup after enabling the dynamic lookup cache?and what is the associate port??????thanks in advance for your time

Manasa

• Dec 6th, 2006

A Lookup transformation using a dynamic cache has the following properties: NewLookupRow. The Designer adds this port to a Lookup transformation configured to use a dynamic cache. Indicates with a num...

adil

• Nov 28th, 2006

Hi,Associate port is either an i/p or o/p .Data in this port is used by IS[Infa Server] to insert or update lookup cache.

Answer Question  Select Best Answer

The informatica server builds a cache in memory when it processes the first row af a data in a cached look up transformation.It allocates memory for the cache based on the amount u configure in the transformation or session properties.The informatica server stores condition values in the index cache and output values in the data cache.

Puli Ramesh

• Dec 6th, 2006

A LookUP Cache is a Temporary Memory Area which is Created by the Informatica Server. which stores the Lookup data based on certain Conditions.  The Caches are  of  Three types 1) Persistent 2) Dynamic 3) Static  and 4) Shared Cache.

srinivas vadlakonda

• Sep 28th, 2006

Lookup cache is the temporary memory that is created by the informatica server to hold the lookup data and to perform the lookup conditions

Answer Question  Select Best Answer

krishnasri424

 Profile Answers by krishnasri424 Questions by krishnasri424

• Dec 7th, 2006

Use sequence generator and set the 'Increment by' property in that with 2.

Pavan.m

• Dec 7th, 2006

Use sequence generator to generate warehouse keys and set the 'Increment by ' property of sequence genrator to 2.

Answer Question  Select Best Answer

PavaniKatta

 Profile Answers by PavaniKatta Questions by PavaniKatta

• Dec 11th, 2006

Source qualifier transformation is used to extract the data from one or more tables from RDBMS of the same instance or from a single flat file system.Application Source Qualifier transformation is used to extract the data from Application sources like ERP.

Answer Question  Select Best Answer

crishnathk

 Profile Answers by crishnathk Questions by crishnathk

• Dec 12th, 2006

thq from ur answer i can come to one conclusion tht ODS is used to store the current data.i can assume tht by defalut it will add tht 40000 records to this current data 10000 records n gives the reslut 50000.cud u plz reply to this......thq...

Sravan Gopisetty

• Sep 24th, 2006

ODS is an Integrated view of Operational sources(OLTP).

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• Dec 12th, 2006

As sravan said, u have to use normalizer. u have to hard code the output ports in the properties of the normalizer transformation to map input ports.Hanu.

sravan kumar

• Dec 8th, 2006

Use Normalizer transformation.

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• Dec 12th, 2006

whether you are loading data from scratch(for the first time) or subsequent loads, there is no changes to the scheduling. The change is how to pickup the delta data.Hanu.

Answer Question  Select Best Answer

Azhar

• Mar 30th, 2006

Can someone guide me on1) Data profiling.2) Exporting independent and dependent objects.Thanks in advance.-Azhar

Rama

• Nov 28th, 2005

Features in 7.1 are :1.union and custom transformation2.lookup on flat file3.grid servers working on different operating systems can coexist on same server4.we can use pmcmdrep5.we can export independ...

Answer Question  Select Best Answer

siva

• Dec 14th, 2006

This is the informatica file watcher event.

vasu

• Nov 20th, 2006

Thanks ramakrishna. thaks for ur answer & reply

Answer Question  Select Best Answer

Abhishek Deodhar

• Dec 14th, 2006

Online Mode : Dynamic Mode.WorkFlow Monitor Updates workflow information automatically fetching updates from server.Offline Mode: Static Mode.Used to see  historic information about work flow runs.

Answer Question  Select Best Answer

tannya

• Dec 15th, 2006

Fact tables always maintain the history records,and mostly consists of keys and measures,So after all teh dimension tables are populated,teh fact tables can be loaded.The load is always going to be a incremental load except for the first time which is a history load.

hanug

 Profile Answers by hanug Questions by hanug

• Dec 11th, 2006

HI:There are two ways u have to load fact table. 1. First time load2. Incremental load or delta loadIn both cases, u have to aggregate, get the keys of the dimentional tables and load into Fact.In case of increments, u use date value to pickup only delta data while loading into fact.Hanu.

Answer Question  Select Best Answer

what do u mean by Confirmed Facts? where it ll use? what is the use of it?

vamsi.yalla

• Dec 17th, 2006

Confirmed facts are reusable and fixed in nature

Answer Question  Select Best Answer

pavithra

• Dec 17th, 2006

Hi,Go to Session-->right click  -->Select Edit Task then Goto -->Config Object then set the property Save Session Log By --RunsSave Session Log for These Runs --->To Number of Historical Session logs you want

srisailu

 Profile Answers by srisailu Questions by srisailu

• Jul 31st, 2006

Hi,     We can do this way also. using $PMSessionlogcount(specify the number of runs of the session log to save) 

Answer Question  Select Best Answer

I have a flat file as my source containing 100 records and i have two load this flat file data into two different targets .these two targets reside in two different sachems actually?

shaik

• Dec 20th, 2006

Yes u can load into different targets with different schema.First check source columns which matching to target table column and then load.

Answer Question  Select Best Answer

1.how to create shortcuts in informatica?2.what are the new features added in informatica 8 version?

Sravan Kumar

• Dec 21st, 2006

U can create a shortcut for object in the shared folder in the same repository.

Informatica_buddy

• Dec 15th, 2006

We can create shorcuts through repository manager.Will have to create a new folder and further selecting property of allow shortcuts.Object created in shortcut folder can be further dragged ...

Answer Question  Select Best Answer

Hi,
I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.
The Target are Oracle tables.
1-80 columns: 1st target
81-200 columns:2nd target
How can I split that single COBOL file data into two data files...

Sravan Kumar

• Dec 21st, 2006

USE NORMALIZER TRANSFERMATION.

Answer Question  Select Best Answer