Answer Posted / nagaraju
push down optimization is used increase the performance.in this concept integration service convert the transformation logic into query and send to the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is incremental aggregation?
What are mapplets?
What is lookup change?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
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?
Can we get 1st record through Informatica(without sequence number).
What are the types of schemas we have in data warehouse and what are the difference between them?
design of staging area?
Define mapplet?
In informatica workflow manager, how many repositories can be created?
What are the transformations that are not supported in mapplet?
What do you understand by SOA of Informatica?
Explain the shared cache and re-cache?