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
Briefly describe lookup transformation?
explain abt ur project architecture?
what is size of u r database?
What is olap (on-line analytical processing?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How union transformation is used?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
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?
What are active transformations.
Explain Dataware house architecture .how data flow from intial to end?
What is difference between a gateway node and worker node?
What is primary and backup node?
Explain the types of lookup transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.