Answer Posted / vas.chiky
for complex results, which we cannot obtain in SQL or from
informatica transformation, we go for procedures.
Also doing the calculation in database level doesnt makes
work load high for our informatica server.
process will be given to database.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you convert single row from source into three rows into target?
What is a pre-defined event and user-defined event?
What is fact table? Explain the different kinds of facts.
How can you increase the performance in joiner transformation?
What are the reusable transformations?
What is a surrogate key?
How to do unit testing in informatica? How to load data in informatica ?
how many types of dimensions are available in informatica?
What is olap (on-line analytical processing?
tell me 5 session failure in real time how can you solve that in your project?
Where are the source flat files kept before running the session?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the measure objects?
Where can we find the throughput option in informatica?
Briefly define reusable transformation?