Recent content by srvu

What will happen when i given connection value (for target) in Mappings tab as well as different connection value for same target in my Parameter file? And what will be the output if parameter file is empty, where i have defined Mapping Parameter at Mapping level and no initial value is defined?

I got answer from the post given by MacLeod72 on running totals.. Port 1: KEY Input Port 2: VAL Input Port 3: V_TOTAL Variable Exp: IIF(KEY != V_KEY, VAL, V_TOTAL + VAL) Port 4: V_KEY Variable Exp: KEY Port 5: RUNNING_TOTAL Output Exp: V_TOTAL Thanks to MacLeod72

Source No Al_No Amt X1 1 20 X1 2 30 X1 3 40 X1 4 50 X2 1 60 X2 2 20 I have a source as above Data that shud be populated in Target No Al_No Amt Prev_buffer_Amt X1 1 20 0 (shud be) X1 2 30 20 X1 3 40 50 (sum...

I have SQL Source which is not having any type of keys all over database. i have to migrate that data to Oracle. Source Master table is having more than 52 lac records, it's taking hours to read data as there is no key defined on source. Think Partitioning source wud be best option to read the...

Target Table (oracle 10g) is having datatype Addr, where 5 columns are embeddedd Addr contains (address1, address2, city_name, district, state, pincode) we have to migrate data from SQL where the above mentioned are 6 different columns having varchar as datatype and pincode is numeric. When...

what type of sources are u having? Are they tables or table+flat file ???

You can refer my thread which i posted from converting signed over punch values, which may be helpful for you. And refer http://en.wikipedia.org/wiki/signed overpunch the above site which may also help u. And the thread is " converting .c3 values.......

Source data is in SQLServer2005 and target is Oracle 9i. Any way Thank u so much for all your suggestions

We have got a new project in which we have to use Informatica 8.1 for migrating all the data from SQLServer to Oracle. So, for migrating the data should we import each and every table into Informatica and perform several different Mappings for all the tables present in SQLSERVER?? What about...

You can use expression transformation to convert date into required format. Use function TO_DATE(datefieldname,'format') To_date(fieldname,'ccyymmdd')

Atlast i have resolved the issue I have filtered all the zero and negative values in exp,and selected Last(amount) Thanks for support

i have filtered maxout and Lifetime amounts in Exp record by record by applying condition maxout!=0 and maxout!=-maxout and similar conditions to Lifetime Now passed to Agg t/r where i need to check max date and max claimline and select maxout at that point where date and claimline is max...

When you are working with fixed width flat file check for the line endings. If your line endings are DOS line endings then add an extra column CRLF with precision 1 to your flat file source and to Source Qualifier and donn pass CRLF further. I had a similar problem when working with fixed width...

I have records as below claimline claimid benededuct maxoutaccrual Lifetimeaccrual date 1 81813 100 25 225 24-08-08 2 81813 0 25 325 27-08-08 3 81813R1 -100...

According to above logic, it should work for amount like 4352.000000 also but it is displaying 4352