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

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

karthikeyan

• May 15th, 2006

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

Answer Question  Select Best Answer

I am asked to create a detailed metadata about ,transformations used in particular fact table mapping.How do i understand and create write up on what has happened to each port during each transformations?By right click on port in target definition and choosing backward path , I could get complete path for that port.Pls. adviseThanks,

motilal

• Jun 30th, 2006

you need to do it manually.In some cases you can see the effects by firing SQL queries in database directly.You may also use debugger to see the path followed if u have the privillege.But The best way is analyse and write the metadata manually.

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

afzal pathan

• May 27th, 2006

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

Answer Question  Select Best Answer

priyamayee

 Profile Answers by priyamayee Questions by priyamayee

• Jun 8th, 2006

Hii, have u impleted using wizards???? If so, create the target with the name u have given in wizard for target(table). No't create the target again for the second instance. It is just the virtual cop...

Answer Question  Select Best Answer

UmaBojja

• Jun 13th, 2006

In the designer go to the main menu and one can see the export/import options.Import the exported mapping in to the production repository with replace options.ThanksUma

Answer Question  Select Best Answer

Uma Bojja

 Profile Answers by Uma Bojja Questions by Uma Bojja

• Jun 16th, 2006

Data can be viewed using Informatica's designer tool.If you want to view the data on source/target we can preview the data but with some limitations.We can use data profiling too.ThanksUma 

Answer Question  Select Best Answer

bala

• Jul 6th, 2006

Hi,   Informatica is a ETL tool.used for the Extraction,Transformation and Loadind of data.This tool is used to Extract the data from different Data Bases and then we can do the required tra...

Answer Question  Select Best Answer

satish

• Aug 3rd, 2006

The major difference is in 8 version some new transformations are added apart from these the remaining same.

Answer Question  Select Best Answer

srinivas

• Sep 28th, 2006

if we are using more business reules or more transformations then it is called complex mapping. If we have flat files then we use the flat as a sourse or we can take relational sources depends on the availability.

Answer Question  Select Best Answer

Aparna

• Jul 18th, 2006

The unconnected lookup is used just like a function call. in an expression output/variable port or any place where an expression is accepted(like condition in update strategy etc..), call the unconnec...

Answer Question  Select Best Answer

Prasanth

• Oct 19th, 2006

Call stored procedure using a shell script.Invoke that shell script using command task with pmcmd.

Answer Question  Select Best Answer

abc

• Jul 14th, 2006

By using command task.

Answer Question  Select Best Answer

Please explain the types of repositories..what is local repository?what is global andwhat is standalone repository?

Bala

• Aug 28th, 2006

There are two types of repositories. one is Local repository and other one is Global repository.Local repository means you can share the data between the folders resdies ony that particular repos...

Answer Question  Select Best Answer

Praveen kumar

• Jul 22nd, 2006

Unit testing are of two types1. Quantitaive testing 2.Qualitative testingSteps.1.First validate the mapping2.Create session on themapping and then run workflow.Once the session is succeeded the right ...

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 23rd, 2006

hi,its very simple thourgh sheduleingthanksmadhu

Answer Question  Select Best Answer

RAGHU

• Aug 10th, 2006

A Junk is not in Informatica it is a concept of Warehousing especially in Dimensional Modelling.  A Junk Dimension is a Dimension in which it consists of attributes or columns which are less likely to use or modify, but may be useful in Future.-ragably21@yahoo.com

Answer Question  Select Best Answer

sharif

• Aug 4th, 2006

Power channel helps to transfer large amount of encrypted and compressed data over LAN,WAN through firewalls ,transfers files over FTP

Answer Question  Select Best Answer