0 - 18 of 18 tags for informatica

Download the Aster Connector for Informatica 9.5. Additional information can be found in the README file.

This package contains the Aster client tools.

<a href = "http://sunitlabs.com/informatica-online-training/">Informatica</a> Online Training|Online Informatica Training|Informatica Online Training in Hyderabad India

 

Informatica Is the best ETL tool Informatica Power Center is a powerful ETL tool developed Informatica Corporation.

 

Hi All,

 

May I have your suggestions in below-

 

In informatica , in sql transformation below code is written -->

 

 

 

BT

collect stats on table_1;

 

ET;

 

Delete from table_2;

 

UPdate table_2 

from table_1....

Greetings Experts,
We are using some jobs that use Mload connection in Informatica.  If the number of rows in ET table is >= errorlimit specified, will the session be forced to fail?

I recently came across a discussion which was debating that PDO is not possible with Teradata 12 and Informatica 9.5.1.
I tried looking for answers but could not find a convincing one. Any idea?

A developer indicated to me that Informatica will not use secondary indexes. Is this true?

 

A third party vendor has developed a data mart application for us and now they are deploying it.  This is a cloud based 

application using Informatica 9.0 and Teradata 13 database. The source data files are comming from different locations

Hi all..
 
i have the query

qualify rank() over (partition.....question

 

in teradata form.  now i need to convert it to infomatica. can anyone help me provide the conversion for the "rank()" in informatica.???

 

thanks in advance..!!

 

Our site recently updated TPT to 13.10. We call tbuild from within a shell script, which in turn is called from a Command Task in Informatica. We've had no problems prior to the upgrade but the 13.10 version of tbuild issues a warning that TMSM has failed to initialize. We don't have TMSM installed.

Hi ,

I have a smiple mapping where I take data from Oracle database ,use expression transformation to add certain parameter values and then push it to teradata box.

Now, it is running fine when I use relational connection however whe I use TPT connection it shows all rows being processed but nothing gets inserted into table.

 

I am trying to connect to Teradata 13.10 using 32bit TTU with 64bit ODBC from Informatica 9.1.  Informatica and ttu/ODBC are installed on Win2008 server.

The compatibility matrix says this should work, but I can't even see the 64bit ODBC driver through SQL Assistant (32bit).

Is this not possible?

Thanks.

Hi all,

 

i am trying to load data in my database using informatica but getting the error that is placed below:

 

Hi all,

 

i am trying to load data in my database using informatica but getting the error that is placed below:

 

 Execute Direct -- [Teradata][ODBC Teradata Driver][Teradata Database] An owner referenced by user does not have INSERT WITH GRANT OPTION access to BATABASE_NAME.TABLE_NAME.ID.Unable to get catalog string.

Business Intelligence Architect
Position Type: Full-Time, Permanent
Company Name: HSGI Inc.
Location: Atlanta, GA
Primary Skills: BI, Architect, Data Modeling, Data Analysis, SQL, Data Warehouse, Data Mart, Dashboards

Urgent Job Opportunity!
Only Serious Candidates Need to Apply! We can set up interviews for you immediately!
Please reply with ALL of the following information:
• An updated copy of your resume in a Word (.doc) Document
• Current and expected compensation
• A brief introduction type paragraph outlining your skills and experience relative to the Job Description

Hi,
I would appreciate if anybody let me know how can i find charset setting of database thru query.

Regards,

Hi,

this is a second post, looks like the former one is lost ...
an attempt to connect INFORMATICA to TERADATA via ODBC returns an error :
[DataDirect][ODBC Teradata Client driver][Teradata]The user does not have SELECT access to DBC.TVM.

Teradata Meta Data Services (a component that is included in the Teradata Utility Pack) helps an organization locate, describe, and share knowledge. Metadata surrounds raw data with context, transforming it into knowledge.