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
Define filter transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is standalone command task?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the designer tools for creating transformations?
How to partition the Session?
Differentiate between sessions and batches?
Mention a few design and development best practices for informatica?
Explain sessions?
How can informatica be used for an organization?
explain about unit testing? in real time?
How identifying bottlenecks in various components of informatica and resolving them?
Differentiate between Load Manager and DTM?
What is joiner transformation?
How can we remove the duplicates from flat file source?