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 8877In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
TCS,
2 11932Let’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 14213Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
4 12838what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
TCS,
2112Hi , 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 7353Post New Informatica Questions
How do you load only null records into target?
Define pmcmd command?
What is union transformation?
What are the main features of Oracle 8i with context to datawarehouse?
How many transformations can be used in mapplets.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain sessions. Explain how batches are used to combine executions?
What is exclusive and normal mode for repository services?
Define Pmrep command?
How to go to the older version for a mapping?
How can we improve session performance in aggregator transformation?
design of staging area?
Differences between connected and unconnected lookup?
How does a sorter cache works?
What are the differences between source qualifier and joiner transformation?