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?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What are Rapid changing dimensions?1 3917
what are challenges that you faced in testing? give solution to it?1 3124
Let’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 10542
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??4 9764
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what are 3 tech challenges/ common issues you face?
Hi , 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 V3 4883
Define filter transformation?
What is target designer and target load order?
What is a repository manager?
what is diff b/t sorter t/r and agg have the option sorter property...
How to start a workflow using pmcmd command?
What do you mean incremental aggregation?
Explain the pipeline partition with real time example?
What is workflow manager?
update strategy transformation in informatica
What are the different versions of informatica?
What is the use of transformation?
What are the different components of powercenter?
Is it possible to create multiple domains on a single Informatica server?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What does update strategy mean, and what are the different option of it?