manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...

Answer Question  Select Best Answer

geetham

 Profile Answers by geetham Questions by geetham

• Dec 28th, 2006

Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected a...

Motilal

• Jun 30th, 2006

Uncached lookup: The informatica server doesnot build a cache for temporary starage of data. Wenever it need to refer to the look up table, it scans the source directly.Dynamic Cache: The informaatica...

Answer Question  Select Best Answer

geetham

 Profile Answers by geetham Questions by geetham

• Dec 28th, 2006

Parameter - Represents a constant value that cannot be changed throughout the session run.Variable - Represents a value that can be changed during session run.There are some functions available to change the variable value like setvariable(), setmaxvariable(),..

DJ

• Nov 30th, 2006

Parameter is a value is assigned at the pre session level and it remains constant through out the sessionvariable will change throughout the session

Answer Question  Select Best Answer

sri

• Dec 28th, 2006

Hi srinu,Can u explain how to "associate sequence"?Thanks,Sri.

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

When we selecting the dynamic  cache in look up transformation the informatica server create the new look up row port,  it will indicates the numeric value wheather the informatica server in...

Answer Question  Select Best Answer

Prasad

• Dec 27th, 2006

Test load is the property we can set at the session property level by which Informatica performs all pre and post session tasks but does not save target data(in RDBMS target table, it writes the data ...

sravan kumar

• Dec 4th, 2006

By Using Look up transformation we can look up A flat file.When u click Look up transformation it shows u the message.Follow that.Test load is nothing but checking whether the data is moving correctly to the target or not.

Answer Question  Select Best Answer

Kuldeep Kumar Verma

• Dec 26th, 2006

Auxiliary Mapping is used to reflect change in one table when ever there is a change in the other table.Example:In Siebel we have S_SRV_REQ and S_EVT_ACT table, Lets say that we have a image table def...

Answer Question  Select Best Answer

jvivek80

 Profile Answers by jvivek80 Questions by jvivek80

• Dec 25th, 2006

Authentication requests validate user names and passwords to access the PowerCenter repository.You can use the following authentication requests to access the PowerCenter repositories: Login Logout Th...

Reddappa C. Reddy

• Dec 18th, 2006

An authenticator is either a token of authentication (is the act of establishing or confirming something or someone) or one who authenticates

Answer Question  Select Best Answer

Anupama

• Dec 22nd, 2006

Power Center supports Partitioning process, where as Power mart only does simple pass through.

sivaprasad

• Nov 7th, 2006

Hi,power center will support global and local repositories and also it supports ERP packages. but, Powermart will support local repositories only  and it doesn't support ERP packages .Power ...

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

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

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

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

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

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

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

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

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

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

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