afzal pathan

• May 27th, 2006

Do the following Map1..Source instance s1---Source qualifier?aggregator transformation---t1(target)                 ...

Answer Question  Select Best Answer

afzal pathan

• May 27th, 2006

Mainly there are two types of tranformation.1]Active TransformationAn active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not ...

Answer Question  Select Best Answer

You can download an IBM Book on Dimensional Modeling from the following link:http://www.redbooks.ibm.com/abstracts/sg247138.html?OpenThis is an excellent IBM Redbook on Data warehouse design and Dimensional Modeling design.Great to read,Dave

sithu

 Profile Answers by sithu Questions by sithu

• May 26th, 2006

Guys,http://freedatawarehouse.com/tutorials/default.aspxCheers,Sithusithusithu@hotmil.com

Answer Question  Select Best Answer

suhas

• May 19th, 2006

You can use the Expression transformation to calculate values in a single row before you write to the target. For example, you might need to adjust employee salaries, concatenate first and last names, or convert strings to numbers.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Expression finds the Primary key is or not, and calculates new flagBased on that New Flag, filter transformation filters the DataCheers,Sithu

Answer Question  Select Best Answer

windows

 Profile Answers by windows Questions by windows

• May 17th, 2006

First of all stored procedures (at DB level) are series of SQL statement. And those are stored and compiled at the server side.In the Informatica it is a transformation that uses same stored procedure...

prasanth

• May 17th, 2006

If you need to call a stored procedure inside your mapping to pass a value to the SP and return or just return values to your mapping you need to use a SP transformation.

Answer Question  Select Best Answer

karthikeyan

• May 15th, 2006

Aggregate calculation like sum,avg,max,min these are the measure objetcs.

Answer Question  Select Best Answer

suresh maddineni

• May 14th, 2006

3 layersgraph development environmentcooperating systementerprise metadata environment

Answer Question  Select Best Answer

Uma Bojja

 Profile Answers by Uma Bojja Questions by Uma Bojja

• May 8th, 2006

Following are necessary1.Power Connect license 2.Import the source and target from people soft using ODBC connections3.Define connection under "Application Connection Browser" for the people soft sour...

Answer Question  Select Best Answer

MOOTATI RAGHAVENDROA REDDY

• May 8th, 2006

Yes, we can stop the batches using server manager or pmcmd commnad

Answer Question  Select Best Answer

Mahesh

• May 5th, 2006

yes, informatica  for load the data form the heterogineous sources to heterogeneous target.

Anant

• Apr 26th, 2006

Yes it can. For example...Flat File and Relations sources are joined in the mapping, and later, Flat File and relational targets are loaded.

Answer Question  Select Best Answer

Uma Bojja

 Profile Answers by Uma Bojja Questions by Uma Bojja

• May 3rd, 2006

When the repo is up and the PMSERVER is also up, workflow monitor always will be connected on-line.When PMserver is down and the repo is still up we will be prompted for an off-line connection with which we can just monitor the workflows previously ran.

Answer Question  Select Best Answer

Uma Bojja

 Profile Answers by Uma Bojja Questions by Uma Bojja

• May 3rd, 2006

I think this will be handled by the database we use.When the operations/loading on the table is in progress the table will be locked.If we are trying to load the same table with different partitions t...

Answer Question  Select Best Answer

raghavendroa

 Profile Answers by raghavendroa Questions by raghavendroa

• May 3rd, 2006

1.union & custom transformation2.lookup on flatfile3.we can use pmcmd command4.we can export independent&dependent repository objects5.version controlling6.data proffiling7.supporting of 64mb architecture8.ldap authentication

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Apr 4th, 2006

I'm a newbie.  Correct me if I'm wrong. In 7+ versions - we can lookup a flat file - union and custom transformation- there is propogate option i.e, if we change any datatype of a ...

Answer Question  Select Best Answer

It displays update information about the session in the monitor window.

kalyan

• May 1st, 2006

It displays the updated information about the session in the monitor window. The monitor window displays the status of each session when you poll the Informatica server.

Answer Question  Select Best Answer

Cholleti Kiran Kumar

• Apr 28th, 2006

            For example u have a table Emp_Name and it has two columns Fname, Lname in the source table which has douplicate rows. In the mapping Crea...

Answer Question  Select Best Answer

Hi all,I am getting the following message when I start theinfa Repository server ..Could not start INFORMATICA Repository SERVER on Local ComputerERROR 1053 : the service did not respond to the start or control request in a timely fashionThis is the first time I found the above problem.Could you plz let me know what might be the reason ..Environment : Win sever 2003 , Oracle 9i and Infa 7.1.1.Thanks...

Guest

• Apr 21st, 2006

Check the connection to the repository database look into the Informatica LOGS

vysu

 Profile Answers by vysu Questions by vysu

• Apr 15th, 2006

you just configure repository server services which r placed in adminstrative tools(services)  .in repository services go to properties click log on and make it local system account.start yo...

Answer Question  Select Best Answer

starg

• Apr 20th, 2006

In informatica there is no method for unit testing. There are two methods to test the mapping.1. But we have data sampling. set the ata sampling properties for session in workflow manager for specifie...

Answer Question  Select Best Answer

sunil_reddy

 Profile Answers by sunil_reddy Questions by sunil_reddy

• Apr 14th, 2006

It only creates a copy of it..

Answer Question  Select Best Answer

sunil_reddy

 Profile Answers by sunil_reddy Questions by sunil_reddy

• Apr 14th, 2006

Joiner transformation compares each row of the master source against the detail source. The fewer unique rows in the master, the fewer iterations of the join comparison occur, which speeds the join process.

vishali

• Apr 14th, 2006

In joinner transformation informatica server reads all the records from master source builds index and data caches based on master table rows.after building the caches the joiner transformation reads records from the detail source and perform joins

Answer Question  Select Best Answer