Search results for query: *

Hi, I have to do the followings using INFA 6.2 mappings / work flows. There is no Unix shell scripts as we are working on Windows. Need to look into the source directory in network for certain set of files, if any one or more of those files is/are found then I need to make an entry in my...

I have a SQL Server table as the source. My mapping will do an insertion to oracle target table T1. And then, will make an entry to another target T2 with the ID from T1 (ID is created by a "after insert" trigger on T1 using Oracle Sequence). If some failure happens then no insertion should...

Well, I had got solution for this. My column name was having space in it. i.e. the column name of MS-Access database table was First Name Last Name ect. Therefore, in my mapping, I did SQL Override at the SQ, where I had to have Select "First Name", "Last Name" from "tblProcessName"...

Well, the business rule is such that, there will never be entries in source table for 2 persons having same first name & last name, staying in same city.

Hi, Here is what, I want to do ...... Source : view in MS-SQL Server Target : Oracle table. Source Data =========== First_Name Last_Name City Do Wyane CA Donev Steve NJ Do Wyane NY Herz Michael CA...

Hi, I am using INFA 6.2. My source is MS-Access database table. Target is the Oracle table. I imported the source table in Source Analyzer, created 'Data Source Name' for respective ".mdb" and used the same for connection. Got the source prepared. But, while doing a "Preview Data" at the...

All, While using External table in Oracle9 for a flat file data, the 1st step involved is CREATE or REPLACE DIRECTORY testdir AS 'c:\ext_dir'; My question is 'c:\ext_dir' is the the Oracle Server directory ? OR a directory in your local machine ? Basically, where should the flat file will...

Well, "STATE_CODE" and "STATE_FIPS_CODE" are the columns. "STATE_FIPS_CODE" needs to be updated if the STATE from flat file (i.e 'AK','CA', ...) is exists in table. By the way the flat file will be like this Zip Code","City","County","State","FIPS" "00008","Tongass National Forest","Prince...

Hi, Pls let me know the steps involved in reading a record form flat file (using UTL_FILE) and then inserting the same into Oracle table if the record does not exist in table and update if it exists. Flat file is as shown here "Zip Code","City","County","State","FIPS" "00008","Tongass...

Hi, I need something like this .... A stored procedure that will read a flat file and will insert /update respective columns in multiple oracle tables. Is it possible to write such a PL/SQl stored procedure ?? Thanx

I find this strange ... My workflow didnt yield any output rows. Session log says zero transformation errors. ***** RUN INFO FOR TGT LOAD ORDER GROUP [1], SRC PIPELINE [1] ***** MASTER> PETL_24023 Thread [READER_1_1_1] created for the read stage of partition point [SQ_T_JOB_PARAMETERS1] has...

Hi, In fact, I am trying something like this. DELETE the target table before new records are inserted through my Work Flow. I tried "Pre SQL" option. It did help me. There are 2 places available where we can have "Pre SQL" option set. One is inside mapping at target instance Properties...

How do you accomplish this within Informatica? 1. There's a source table that's used to do the insertion into a destination table. It finds all rows in the source table with PROCESSED_FLG = 'N'. 2. There's a different informatica job that then goes back through the source and destination...

Guys, Is there any way to control the flow of execution inside a mapping ? Lets say, I have a Source Qualifier from which 2 links go to connect to 2 different targets. Now, how to know which target is getting affected 1st and which is the next .... If I want to change the order (to affect...

" event-based scheduling, indicator files " is not helpful for this situation ...

Hi, In Informatica schedule, I have to something like this ... Run the Work Flow, every Monday to Friday from 2 am to 5 am each 15 minutes. How to do this ? I did some trial and error and could find that We can do a scheduling for the daily basis in certain frequency, but not within a time...

Have you guys ever used more Stored Procedure transformations inside Informatica mapping ? In my case, I have 12 stored procedures transformations used inside mapping. Off couse, these mappings are taking one input and retruning 1 output after a lot data processing being done at each SPs. What...

Guys, The situation is like this .... We have 14 work flows all togather, shceduled for mid-night every day. Each of those starts executed whenever it gets corresponding Indiacator file on/after the scheduled time. Now, we have to do some thing like ths .... Our 15th Work Flow needs to start...

I want to avoid Java n stuffs ... Is there any other way ??? Any body out there ... I need a .BAT file (MS-DOS batch file) make to run from Oracle PL/SQL. Thanks

Well, the situation is like this. Each of my 14 mappings is inserting single row into Oracle table T_Job_Progress. So, on 14th insertion into this table, I need to run my 15th Work Flow.