can we create index and drop index in exsisting table while
using infomatica
Answer Posted / roshan
one more way is to write stored procedure and use target pre load and target post load option using unconnected stored procedure T/R...
for more detail
infernonag@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Define joiner transformation?
Target increases every day even though no new record was inserted
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the different types of repositories created using informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Tell me about Propagate functions in informatica
Design a mapping to load the cumulative sum of salaries of employees into target table?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the different versions of informatica?
How to configure mapping in informatica?
How to load data in informatica ?
Briefly explain the aggregator transformation?
What do you understand by SOA of Informatica?
Enlist the differences between database and data warehouse.