calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 22nd, 2006

Hi,Name itself it is saying that agent means meadiator between and repositary server and reposatary database tables. simply reposatary agent means who speaks with reposatary.thanksmadhu

chsrgeekI

 Profile Answers by chsrgeekI Questions by chsrgeekI

• Sep 13th, 2006

Hi,   The Repository Server uses a process called Repository agent to access the tables from Repository database.The Repository sever uses multiple repository agent processes to manage multiple repositories on different machines on the network using native drivers. chsrgeekI

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 22nd, 2006

himapping is nothing but flow or work. where the data is coming and where data is going. for this we needmapping namesource tabletarget tablesession.thanksmadhu

sperumandla

 Profile Answers by sperumandla Questions by sperumandla

• Sep 21st, 2006

Please let me know the answer for this question.

Answer Question  Select Best Answer

manojkumarkurnool

 Profile Answers by manojkumarkurnool Questions by manojkumarkurnool

• Feb 13th, 2008

flatfile is only a permanent store age device means it flow only read processbut dynamic cache is used for read and wirte process so  in a flat file u cannot use a dynamic cache in flatfiles

chandrarekha

 Profile Answers by chandrarekha Questions by chandrarekha

• Feb 6th, 2008

You can use dynamic chache in flat files with new versions after 7.1.1

Answer Question  Select Best Answer

superhero

 Profile Answers by superhero Questions by superhero

• Dec 12th, 2008

Take two normalizer transformation,pass 1to 81 colomns to N1,81-200 N2.then do the operations in normalizers what ever you want and pass the records from n1- t1 and n2 -t2.

Sharad

• Jan 17th, 2007

Createa a temp stage table, load all the columns in it. The extract all columne from staging table and populate both tgt tables as you want.Cheers.Sharad

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

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 11th, 2012

When an Aggregator transformation is used without sorter, it stores all the data before performing the grouping operation. But when a sorter is used before aggregator, it sorts all the data before pas...

sai

• Feb 14th, 2007

passing data to sorter is time taking why because sorter transf stores whole data in buffer and then sorts based in specified ports.insted of passing data to sorter transf ,sort d data in the sours...

Answer Question  Select Best Answer

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• May 11th, 2010

There are multiple ways to do it src-->seq gen --> trans --> tgtUse a seq gen to get transaction id1) Filter TransUse filter to filter in transaction id<=102) RouterRoute transaction id<...

afzal

• Nov 3rd, 2006

hi,For falt file sourecsource--sq--sequence generator tran.on new fileld id--filter tran. id<=10--traget

Answer Question  Select Best Answer

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