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
What does role playing dimension mean?
What is mapping debugger?
what is the -ve test case in your project.
What is a dimensional model?
What happens when a session fails and you click on recover?
can you please explain me pre session and post session options?
Where are the source flat files kept before running the session?
How to elaborate tracing level?
How to configure mapping in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
I have a flat file, want to reverse the contents of the flat file
What is a difference between complete, stop and abort?
What does “tail –f” command do and what is its use as an Informatica admin.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
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?