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

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

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

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

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

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

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

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

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...

Appadu Dora P

• Apr 25th, 2006

Time Dimension will generally load manually by using PL/SQL , shell scripts, proc C etc......

Answer Question  Select Best Answer

vamsi Krishna.k

• Dec 29th, 2006

what sangeeta told is right, we can execute shell scripts using command task. Here I'm adding few more points.1) Shell script can be executed using presession and post session commands at sessions.2) ...

geetham

 Profile Answers by geetham Questions by geetham

• Dec 28th, 2006

 Shell Scripts are called through command tasks in a informatica workflow to do the following,   - To send a startup email after the start of workflow.   - To append date to t...

Answer Question  Select Best Answer

When i start the informatica services for loading in workflow manager, the informatica services shows running status but when i see the properties service, status has stooped. With-in sec services has stopped when i was trying to start the services for informatica, how can i overcome this problem?

vamsi

• Dec 31st, 2006

first u start the Informatica repository server service and then u start the informatica service in services.try it it may work.bye

Answer Question  Select Best Answer

Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.

Sridhar Tirukovela

• Jan 2nd, 2007

Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Use a Lookup transformation in your mapping to look up data in a relational table, view, or synonym. Import a lookup definition from any relational database to which both the Informatica Client and Server can connect. You can use multiple Lookup transformations in a mapping.Cheers,Sithu

Answer Question  Select Best Answer

geetham

 Profile Answers by geetham Questions by geetham

• Jan 3rd, 2007

- To do lookup on flatfile, only static cache can be used.

priyamayee

 Profile Answers by priyamayee Questions by priyamayee

• Jun 8th, 2006

Hii, We use dynamic cache only for connected lookup. We use dynamic cache to check whether the record already exists in the target table are not. And depending on that, we insert,update or delete the ...

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

global repository in 7.1 versionnew cutom transformation,normalizer transformation added in 7.1

muzamil

• Aug 2nd, 2006

hiFew differences or the enchancements in 7.1 which i have noticed are Versioning in 7.1, Recovery, Can lookup flat filesso these are the differences. Best RegardsMuzamil

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

Session failed after loading 10000 records, opb_server_recovry file loads the records, it maintains the record id, correct the error again run the session , session will take 10001 record on words

ravi guturi

• Jan 5th, 2007

Yes, we will find out discarded rows by using row indicator and coloum indicator..Row inidicator:DONTD-validO-overflowN-nullT-truncateColumn Indicator:01230-insert1-update2-delete

Answer Question  Select Best Answer

jyoti

• Jan 9th, 2007

yes we can access data from previous version of repository from latest version.regardsjyoti

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 9th, 2007

event based scheduling is using for row indicator file. when u dont no where is the source data that time we use shellcommand,script, batch file to send to the local directory of the informaticaserver is waiting for row indiactor file befor running the session.

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

In time based scheduling, the jobs run at the specified time.  In some situations, we've to run a job based on some events like if a file arrives then only the job has to run whatever the time it is.  In such cases, event based scheduling is used.  

Answer Question  Select Best Answer

Achut Perumbala

• Jan 9th, 2007

Even i encountered the same issue and i did to following to resolve the issue:1. First Delete the Server from Workflow manager.2. Configure the Server Again and give ur IP while configuring and resolv...

rajani

• Oct 10th, 2006

1. IF you have both Informatica server and client installed on same machine then first turnoff any anti-virus software running, turnoff internet connection.2. Check the settings in workflow server and try again.I hope it resolves your problem.

Answer Question  Select Best Answer