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 7240In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
TCS,
2 10643Let’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 12418Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
4 11244what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
TCS,
1609Hi , 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 6017Post New Informatica Questions
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the difference between a repository server and a powerhouse?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the data movement modes in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to generate sequence numbers using expression transformation?
permutations of mapplet
What are the issues you have faced in your project? How did you overcome those issues?
Under what condition selecting sorted input in aggregator may fail the session?
What is repository manager?
What is complex mapping?
How to join three sources using joiner?
Explain the scenario which compels informatica server to reject files?
Can we change Dynamic to Static or Persistent cache? If so what happens?