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

sm1506

• Apr 8th, 2006

vamshidhar,How do u convert rows to columns in Normalizer? could you explain us??Normally, its used to convert columns to rows but for converting rows to columns, we need an aggregator and expression ...

Vamshidhar

• Jan 11th, 2006

Hi,By using Normalizer transformation we can conver rows into columns and columns into rows and also we can collect multile rows from one row

Answer Question  Select Best Answer

sm1506

• Apr 7th, 2006

Most complex logic we use is denormalization. We dont have any Denormalizer transformation in INformatica. So we will have to use an aggregator followed by an expression. Apart from this, we use most ...

Answer Question  Select Best Answer

Naren

• Mar 29th, 2006

Also known as Junk DimensionsMaking sense of the rogue fields in your fact table..Please read the article http://www.intelligententerprise.com/000320/webhouse.jhtml 

thiyagarajanc

 Profile Answers by thiyagarajanc Questions by thiyagarajanc

• Mar 15th, 2006

Plz explain me Clearly what is meant by Mystery Dimension?

Answer Question  Select Best Answer

Ray

• Mar 22nd, 2006

Always remember when designing a mapping: less for moredesign with the least number of transformations that can do the most jobs.

premlahari

 Profile Answers by premlahari Questions by premlahari

• Dec 13th, 2005

There is no such limitation to use this number of transformations. But in performance point of view using too many transformations will reduce the session performance. My idea is "if needed ...

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 13th, 2006

Complex maping means involved in more logic and more business rules.Actually in my project complex mapping isIn my bank project, I involved in construct a 1 dataware houseMeny customer is there i...

satyam_un

 Profile Answers by satyam_un Questions by satyam_un

• Mar 13th, 2006

Complex mapping  means having more business rules .

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

simply man,Cleansing:---TO identify and remove the retundacy and inconsistencysampling: just smaple the data throug send the data from source to target

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

There is a lot of diffrence between informatica an Ab InitioIn Ab Initio we r using 3 parllalisimbut Informatica using 1 parllalisimIn Ab Initio no scheduling option we can scheduled manully or pl/sql...

Niraj Kumar

• Feb 24th, 2006

in Informatica there is the concept of co-operating system, which makes the mapping in parallel fashionwhich  is not in Informatica

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

ya shoor,Just right click on the particular session and going to recovery optionorby using event wait and event rise

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

Normalizer: It is a transormation mainly using for cobol sources,it's change the rows into coloums and columns into rowsNormalization:To remove the retundancy and inconsitecy

Answer Question  Select Best Answer