Answer Posted / rajbir
We use stored procedure transformation top evalate the
expression for rows at database level so that we can use it
again n again according to our requirment
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is mapping debugger?
What do you mean incremental aggregation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How can a transformation be made reusable?
What are the main issues while working with flat files as source and as targets ?
What is flashback table ? Advance thanks
draw informatica architecture 8.6 ?
Explain how to import oracle sequence into informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How do you load first and last records into target table?
Target increases every day even though no new record was inserted
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 is domain and gateway node?