RE: Unable to connect to the ORACLE through INFORMATICA

Thanks Ameet The issue got resolved. -----Original Message----- Hi Infode

informatica-l

Messages for informatica-l

No replies...... :|

HI, I have ampping while will load around 40 million records as inserts fro

Ronaldo is right. If you are not able to see the pushdown optimization then

Can you provide a bit more details on this. What kind of testing are you pl

can any one provide me the temlate for ETL Test Plan based on the standard

Hi, Q)u have 2 sources. 1 for each country location. They both have same se

Hi.. Pls refer installation and configruation guide step by step if you are

Do you have any other database installed in your system other than oracle ,

I checked the database access (between I am oracle DBA ) so I did checked a

Check whether parameters was correctly set from parameter file. Get session

While creating repository you must have given user id and password of the d

I will suggest you to execute the sql in the oracle sql plus and see how mu

Hey are you sure that you are populating the sequence value from "NEXTVAL"

yes ,send me the log to thiyaga11@gmail.com On Thu, Jul 2, 2009 at 8:13 AM,

If you have power center 8.x ,you have to Login to the admin console and lo

thiyagarajan-rajen 'Log Source Row Data' is not what I am looking for. My

If the reset option isn't set, there is no reason the sequence generator sh

You are not being very forthcoming here... "There are not many transformati

Hi! I'm looking information about how to install and setup a development an

Guys, U can do this like below where $$VALUES = BA,AB,BC ( no quotes pls)

use the partitoning in the session and divide the whole 28m records into re

Has your company the license? Ronaldo. On Thu, Jul 2, 2009 at 2:25 PM, rote

u can create a new parameter file with the required information from the 2

Hi, I am using Informatica 8.1.1 and I can't find the pushdown optimization

Thanks for the reply. the second approach is whereI going for. using 2 parm

How do I access the table PowerCenter(8.6) the list of groups and their use

Try to use hash join in the SQL On 7/2/09, simikishore via informatica-l i

Hi thiyagarajan-rajen , Is there an email I can send the session log or sho

Hi manish, As Harish told you can implement using Target table update over

hi Harish thnx for the post. i saw what you mentioned and looks like they a

Hi. Create output ports in the expression and hardcode field names which yo

Hi, Is it possible to use the field names instead of the field values in an

Hi Shastry, What samzo said is correct , But using DATE_DIFF can mention th

No. I havn't check the Reset Option also none of the other mappings loading

Hi.. Can you reset and set the scheduling time again and see if it works. T

Rajiv thanks for ur quick replay. All other workflows in the same server ar

Hi, I guess you can acheive this using informatica scheduler itself. Check

Check the timing on the server where informatica is installed ? /Rajiv

Hi... Cant find the C* program... /Rajiv

Hi gurus, we have a situation like this, one workflow is scheduled at 11:00

Hi, I have this c*program that reads the file generated by informatica and

Have you tried creating a new mapping in the same? More on this, pls. go to

Hi, Vista is not supported with INFA. Simply change your base OS and then d

Hi, You can write the custom SQLs using the Target Override property availa

while creating repository it does not ask for username and password or do y

Try to use the domain user name and password to create repository service a

In informatica ,you can very well log the source data to a DB table.Try usi

Wouldn't calling a Stored Procedure for every row slow down the performance

Hi , I am getting the same error The following error occurred while perfor

Create stored procedure which performs custom insert as per your requirment

Hi.. Donot output header or metadata to the target, instead create header r

Try this... Declare two variables, v_VAR1 of integer/double type and v_VAR2

Source is an sql which joins two Oracle tables. Target is a flat file. Sour

Hi, The source is an SQL which joins two Oracle tables. Target is a flat fi

Well, I wish to create a simple mapping : DB2 as source->Source Analyser->T

Please tell us whether the source and target DB are one and the same or not

You should be able to handle the custom part in informatica mapping itself.

Hi, I am trying to extract records from a huge DB. As the I increase the da

Hi, I want to enquire if I can write custom INSERT SQL statement for a tar

Hi, I am newbie to Informatica, although I have sound understanding and ex

Correct me if i am wrong, you have only one source instance which has simil

couple of ways you can do this - Parameterize the Source table ($$SRC_TBL)

If it is taking 10 mins from Oracle it should take ~ same time from SQ Tra

Did you try to get the count alone against the oracle table and see how muc

Hi Guys, I have a situation which might be more familiar to many. I have 2

Hi, I have an issue WITH THE Informatica MAPPING?.. I have a mapping which

You are taking the substring of a number. What are you trying to do?

I ran into same issue. -- The following error occurred while performing a r

Hello everyone, Please suggest me the best way for performing the arthemeti

This has come up before. It is a known problem, some have already opened a

Hi, While targeting to a flat file (with the field names), it looks like in

Thanks Rishi. That was very helpful. ________________________________ From

Here is my solution.I hope your row count is less. I do it using three pipe

Hi, do I understand transactions well, if I think, that when transaction of

Hi, Please check the config.bat file set the following as per your machine

alternatively you can call both scripts from one script... For instance scr

yes...you can do it...add multiple commands in the command task. /Rajiv

I am using windows only,I am trying the same way as you told but still faci

Hi Please let me know whether we can trigger 2 scripts using a single comma

Hi.. You can also find/connect to AdminConsole from the Startup->Programs->

Hi.. You should specify domain hostname ie., m/c on which informatica is in

Use this ADD_TO_DATE(sysdate,'ddd',-1) Regards Balakrishna

Hello Friends, I am not able to open the admin console window, when i am tr

Hi, I would like to schedule a workflow in Informatica 8.6 to run dai

Hi.. Pls try this method... |->cmd Start->Timer1->Session1 |->T

Hi Rajiv, thanks for your reply. I tried connecting with the Administrator-

Hi.. When you installed informatica on the windows machine you were prompte

Hi, You can populate the data in an excel file (*.csv) and then use the On

Hi Harish, thank you very much for the answer, but I'm already using the us

Hi BNR, Please share your mapping logic with us. Regards, Vikas. __________

Hi, You need to use the same username and password, which you have used dur

Hi, You cannot use the variable's declared inside the worklet in your workf

You can make a stored procedure for comparing the row counts and it should

You can also check for the property where on running the session the target

Hi Sunil, Just i mentioned 30 records as example we want to load more than

Hi experts, we are facing the error of 'execution terminated unexpectedly'

Hi.. Apply correct filter on the update pipeline. May be your condition is

Just an addition I did this til now Flow 1: A.txt_>SQ->EXP->A oracle TARGET

I have a urgent requirement and my logic is not working: I have a flat file

I have created a type 1 dim, looks like everything is working fine. I am te

RE: Unable to connect to the ORACLE through INFORMATICA

informatica-l

3 juillet 2009 : RE: Custom SQL for inserting data in Target Table

3 juillet 2009 : Infa load is going very slow

3 juillet 2009 : Re: Using Pushdown optimization option

3 juillet 2009 : RE: Standard ETL Test Plan

3 juillet 2009 : Standard ETL Test Plan

3 juillet 2009 : Re: Loading 2 source data into single target

3 juillet 2009 : RE: informatica 8.1.1 installation on oracle 10g

3 juillet 2009 : Re: informatica 8.1.1 installation on oracle 10g

3 juillet 2009 : RE: informatica 8.1.1 installation on oracle 10g

2 juillet 2009 : RE: mapping parameter

2 juillet 2009 : Re: informatica 8.1.1 installation on oracle 10g

2 juillet 2009 : Re: through put from session

2 juillet 2009 : Re: Issue in Sequence Generator

2 juillet 2009 : Re: Mapping running for 17 hours

2 juillet 2009 : Re: PowerCenter - the list of groups and their users?

2 juillet 2009 : RE: Custom SQL for inserting data in Target Table

2 juillet 2009 : RE: Issue in Sequence Generator

2 juillet 2009 : RE: Mapping running for 17 hours

2 juillet 2009 : Development and Production Repositories

2 juillet 2009 : RE: IN function

2 juillet 2009 : Re: Mapping running for 17 hours

2 juillet 2009 : Re: Using Pushdown optimization option

2 juillet 2009 : Re: Loading 2 source data into single target

2 juillet 2009 : Using Pushdown optimization option

2 juillet 2009 : RE: Loading 2 source data into single target

2 juillet 2009 : PowerCenter - the list of groups and their users?

2 juillet 2009 : Re: Mapping running for 17 hours

2 juillet 2009 : RE: Mapping running for 17 hours

2 juillet 2009 : Re: Custom SQL for inserting data in Target Table

2 juillet 2009 : RE: Source Analyzer Menu tool disabled.

2 juillet 2009 : RE: Field Name

2 juillet 2009 : Field Name

2 juillet 2009 : RE: Add two dates fields to date field

2 juillet 2009 : RE: Issue in Sequence Generator

2 juillet 2009 : RE: Problem with Scheduling

2 juillet 2009 : RE: Problem with Scheduling

2 juillet 2009 : RE: Schedule workflow to run between intervals daily

2 juillet 2009 : RE: Problem with Scheduling

2 juillet 2009 : RE: Convert the C*program to informatica.

2 juillet 2009 : Problem with Scheduling

2 juillet 2009 : Convert the C*program to informatica.

2 juillet 2009 : RE: Source Analyzer Menu tool disabled.

2 juillet 2009 : RE: Error - [PCSF_10007] Cannot connect to repository

2 juillet 2009 : RE: Custom SQL for inserting data in Target Table

2 juillet 2009 : RE: informatica 8.1.1 installation on oracle 10g

2 juillet 2009 : Re: informatica 8.1.1 installation on oracle 10g

2 juillet 2009 : Re: Custom SQL for inserting data in Target Table

2 juillet 2009 : RE: Custom SQL for inserting data in Target Table

1er juillet 2009 : RE: informatica 8.1.1 installation on oracle 10g

1er juillet 2009 : RE: Custom SQL for inserting data in Target Table

1er juillet 2009 : RE: targeting to a flat file

1er juillet 2009 : RE: Best Way of using Arthemetic operations

1er juillet 2009 : RE: through put from session

1er juillet 2009 : RE: through put from session

1er juillet 2009 : RE: Custom SQL for inserting data in Target Table

1er juillet 2009 : Re: through put from session

1er juillet 2009 : Re: Custom SQL for inserting data in Target Table

1er juillet 2009 : through put from session

1er juillet 2009 : Custom SQL for inserting data in Target Table

1er juillet 2009 : Source Analyzer Menu tool disabled.

1er juillet 2009 : Re: Loading 2 source data into single target

1er juillet 2009 : Re: Loading 2 source data into single target

1er juillet 2009 : Re: Mapping running for 17 hours

1er juillet 2009 : Re: Mapping running for 17 hours

1er juillet 2009 : Loading 2 source data into single target

1er juillet 2009 : Mapping running for 17 hours

1er juillet 2009 : RE: Best Way of using Arthemetic operations

1er juillet 2009 : RE: Error - [PCSF_10007] Cannot connect to repository

1er juillet 2009 : Best Way of using Arthemetic operations

1er juillet 2009 : RE: targeting to a flat file

1er juillet 2009 : targeting to a flat file

1er juillet 2009 : Re: Outputing to excel and attach it to email

1er juillet 2009 : Re: mapping with rowcount compare

1er juillet 2009 : Transaction and Aggregator

1er juillet 2009 : RE: DAC Server failed to start

1er juillet 2009 : RE: how to trigger 2 scripts using a single command task

1er juillet 2009 : RE: how to trigger 2 scripts using a single command task

1er juillet 2009 : RE: AdminConsole Window Problem