After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
TCS,
3 8750In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
TCS,
2 11813Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
5 14049Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
4 12703what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
TCS,
2059Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
3 7231Post New Informatica Questions
What is a router transformation?
How to create Target definition for flat files?
difference between repository database and repository service?
can anyone suggest best free Talend data integration training online
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are batches?
How do you load first and last records into target table?
Explain sessions. Explain how batches are used to combine executions?
Why is sorter an active transformation?
can you please explain me pre session and post session options?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is persistent lookup cache?
How to load data in informatica ?
What is a difference between complete, stop and abort?