sivaprasad

• Nov 7th, 2006

in informatica7.11. we can take flatfile as a target 2.flatfile as lookup table3.dataprofiling&versioning4.union transformation.it works like union all.thanks &regardssivaprasad

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Nov 6th, 2006

load manager is a manager who will take care about the loading process from source to target

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 24th, 2006

After creating the mapping each mapping can be tested by the developer individualy

raja147

 Profile Answers by raja147 Questions by raja147

• Nov 21st, 2006

Hiutps are done to check the mappings are done according to given business rules.utp is the (unit test plan ) done by deveploper.

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 8th, 2007

Yes any user can run the wizard if its under the administrator group.

Ajay Kumar Mohanty

• Jan 22nd, 2007

Yes the created user can run the wizard if its under administrator group with the publics

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

Complex mappings means not a map with more than 100 transformations used in.Even 5 transformations used mapping also called complex enough.It depends on business logic. If the requirement has too much...

Usha

• Nov 29th, 2006

In real time as per business logic we need to build the mapping using number of transformations, for example if you are trying to pass millions of rows with number of transformations and writing sql o...

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

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 8th, 2007

Look of transformation we r using to tally the records of source and target.The main things r as under1.To get the related values between source and target.2.Used for caluculation purposes.3.Slowly changing dimensions.

sivaprasad

• Dec 4th, 2006

the main uses of lookup transformation is:1.get the related values2.used for caluculations3.slowly changing dimensions

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

sandrag

 Profile Answers by sandrag Questions by sandrag

• Feb 7th, 2007

The SQL override works first when compared to any other means of conditions used in the source qualifier.

Satish

• Dec 6th, 2006

Well Sql over ride wud execute... it wud over ride wht ever condition in the mapping......................................

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

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

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

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

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

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

lingesh kumar

• Jan 31st, 2007

Hi U can transfer file from one server to other..............In unix there is an utililty XCOMTCP which transfer file from one server to other. But lot of constraints they are for this..... ...

creativehuang

 Profile Answers by creativehuang Questions by creativehuang

• Jan 8th, 2007

ftp targetaddressgo to your target directoryftp> ascii or binftp> put or get

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

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

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

toffycoffy

 Profile Answers by toffycoffy Questions by toffycoffy

• Feb 27th, 2007

A stored procedure call is made thru an ODBC connection over a network (sometimes the info server resides on the same box as the db)...since there is an overhead in making the call, it is inherently slower.  

Gayathri84

 Profile Answers by Gayathri84 Questions by Gayathri84

• Jan 18th, 2007

Stored Procedures are Hard to maintain and Debug . Maintaince is simpler in Informatica. Its a User friendly tool.Given the Logic. Its eaier to create a Mapping in Informatica than write a Stored Procedure.Thanks,Gayathri

Answer Question  Select Best Answer

I have two variable ports v1 and v2; v2 is calculated based on v1. What will be the value of v2 for the first time, if the order of ports evaluation is v2 and v1

satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Feb 5th, 2007

The PowerCenter Server does not set the initial value for variables to NULL. Instead, the PowerCenter Server uses the following guidelines to set initial values for variables: Zero for numeric ports E...

Guest

• Feb 5th, 2007

The PowerCenter Server does not set the initial value for variables to NULL. Instead, the PowerCenter Server uses the following guidelines to set initial values for variables: Zero for numeric ports E...

Answer Question  Select Best Answer