Search results for query: *

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?

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...

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...

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...

I have Amount field which have value as below say 148.90,148.99 Requirement is to remove the decimal and left pad with zero's.Precision is 9 Value 148.99 is converted correctly as 000014899 but coming to 148.90 its displaying as 000001489, but testers claims it to be 000014890 When we convert...

i have a table T1(master) where i agg sum(values) based on enrollid and accumid. values are enrollid accumid value 123 212 200 123 213 300 123 214 400 Now i have an other table T2(detail) where i need to join with T1 i need to use master outer join T2 is...

I have 1 flat file with 5 diff structures 1st row is header which is 1 for flat file 2nd is pharma record which is one for pharma from 3 claim records under each pharmacy i have imported them each time with diff structure now i have to send them to 3 diff tables header record to header table...

I have two tables T1 and T2 T2 is having amt fields where on joining two tables i get set of records(cartesian records). I should add amts of those cartesian records or records with same PK and get one single record for set of records. (i have checked that condition in EXP and flag rows to...

Hi, In production environment i need to load file data on daily basis,so the file name format should be xxxxxMMDDYYYYHHMMSS.txt How can i name this file and send the sysdate to a file name and what is the criteria which checks the date & performs load function Thank you

Hi I have a flatfile which contains data in different formats. like fixedwidth,delimited etc How can we import the file Thanks in advance

I have source as .c3 files,in that we have amounts column where data in that is in format"s9(7)v99" and sample data is as below Amount- 00799{00000{ hint is given as below Values are formatted using COBOL "signed overpunch" codes and link given is http://en.wikipedia.org/wiki/signed overpunch...

In my Mapping i have used 10 tables from two databases(in SQL SERVER) I have some conditions on data which i have given in SQ trans i.e i have used two SQ's 1st SQ trans to join tables coming from one database A 2nd SQ trans to join tables coming from other database B later i have used two...

Suppose there are two tables where i need to join their columns & extract a some other field from second table Ex: table1.no=table2.no & need to get table2.id then which table is to be considered as lookup table??? Here we can use sourceQualifier directly,but can we use lookup in such a...