Sphurti

• Aug 1st, 2006

Hi,Export your mapping to XML file and then Import it to Client machine .  I am assuming here the client and your system as same version and environment for Informatica.-Sphurti.

Answer Question  Select Best Answer

i want to send the excel sheet as a source to another excel sheet as target.so i created a mapping with source excel sheet to target excel sheet correctly. but i'm failing to enter the correct connection string in establishing relational connections for type ODBC .My ODBC data source is XL(Microsoft Excel Driver(*.xls)). tell me what is the connection string for ODBC (Like oracle is the conn...

Mohamed Ismath

• Aug 14th, 2006

Save the source excel sheet as *.csv that is comma delimeted file and then you can import as flat file..Now you are trying to import source and traget as ODBC and there by when you connect the traget ...

Answer Question  Select Best Answer

rammohanreddy

• Aug 21st, 2006

Informatica versions:Version 5.1 was released July 2001 Version 6.0 was released September 2002 Version 6.1 was released December 2002 Version 6.2 was released April 2003PowerCenter 7.1(only) in Nov'2003

Answer Question  Select Best Answer

nag

• Sep 9th, 2006

Hi, first of all start u r oracle 10g,install u r informatica 7.1.1 in u r laptop,after installing it will show u the informatica server and informatica administration console so uncheck that,u r successfully installed informatica 7.1.1 in u r laptop.

Answer Question  Select Best Answer

anand

• Oct 4th, 2006

definatly

Answer Question  Select Best Answer

I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance

Talk2Raghu

 Profile Answers by Talk2Raghu Questions by Talk2Raghu

• Sep 4th, 2006

hi, you can use an expression transformation and by creating an outport,you can try to convert the data depending upon the nature of it, like  to_char,to_date etc if you are not satisfied then please pose your question once again in detail.bye

Answer Question  Select Best Answer

What is the difference between informatica7.1 and new version 8.1,what are the advantages in new version 8.1.

Ramakrishna Rao Vaka

• Oct 12th, 2006

Hi,The new Version Informatica 8.1 has got some additional feature's like:1) Mapping Generation Option2) Push Down Optimisation3) Data Cleanse and Match4) Data Federation (EII)5) Enterprise Grid6) Hig...

Answer Question  Select Best Answer

The informatica server follows instructions coded into update strategy transformations with in the session mapping to determine how to flag records for insert,update,delete or reject. If you do not choose data driven optionn setting, the informatica server ignores all update strategy transformations in the mapping

fazal

• Sep 7th, 2006

Once you load the data in your DW,you can update the new data with the following options in your session properties:-1.update 2.insert2.delete and datadriven, and all these options are present in your...

Answer Question  Select Best Answer

kaliprasad

• Sep 28th, 2006

The new features in informatica 7.1 are:1.The repositry is going to create with 247 database objectsin informatica7.1 where as in informatica 6.0 repositry is createed with 172 database objects.2.union transformation is added newly in infomratica 7.1

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 22nd, 2006

question was not clear can u repeat this question with full descritpion because there is no specific costing functions in informatica.thanksmadhu.

Answer Question  Select Best Answer

Annapurna

• Sep 20th, 2006

I think u r using old versionof Informatica it seems!!   right, if u install advanced version of Informatica (frm 6.0 onwards) then u will definitely solve ur problem,y bcz these all versions al supports 2 REPOSITORIES not like in 5.1(old version).try it!!! GOOD LUCK!!

Answer Question  Select Best Answer

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

Using source analyzer and warehouse designer

Answer Question  Select Best Answer

R

• Sep 26th, 2006

You have to a string variable to input a date field, and while using it in mapping u need to convert it to date format . to_date(val,'format')

Answer Question  Select Best Answer

opbang

 Profile Answers by opbang Questions by opbang

• Sep 26th, 2006

Bottleneck in Informatica  Bottleneck in ETL Processing  is the point,  by which the performance of the ETL Process is slowr.    When ETL Process is in progress, first th...

Answer Question  Select Best Answer

opbang

 Profile Answers by opbang Questions by opbang

• Sep 26th, 2006

You can develop global and local repositories to share metadata: Global repository. The global repository is the hub of the domain. Use the global repository to store common objects that multiple deve...

Answer Question  Select Best Answer

srinivas vadlakonda

• Oct 11th, 2006

key range: The informatica server distributes the rows of data based on the st of ports that u specify as the partition key.Round robin: The informatica server distributes the equal no of rows for each and every partition. 

Answer Question  Select Best Answer

dwinfo

 Profile Answers by dwinfo Questions by dwinfo

• Sep 28th, 2006

I think the question is :If EMPID is in 5th column/port(in source qualifier), DEPTNO is in 7th column/port(in source qualifier) and if we use No.of Sorted Ports as 2. How will informati...

Answer Question  Select Best Answer

Raj

• Oct 5th, 2006

its depends for client requirements.initially we have implement?high level design?.so,the client want to be normalized (snow flake schema) or de-normaliized data (star schema) which is used for their analysis.so we have implemented whatever their requirements

Answer Question  Select Best Answer

Vamsi Krishna.K

• Oct 1st, 2006

hello,we have to update target table. if you are loading type-1 dimension,type-2 dimension data at target surly you have to do. this update can be done by two type.1. using update stratergy2. target update override.Thanks,vamsi.

Answer Question  Select Best Answer

lingesh

• Oct 5th, 2006

Yaa we can refresh materialized view. While creating of materialized views we can give options such as refresh fast and we can mention time so that it can refresh automatically and fetch new data...

Answer Question  Select Best Answer