All the mappings cannot be validated simultaneously because each time only one mapping can be validated.
Values can be calculated in single row before writing on the target in this form of transformation. It can be used to perform non aggregate calculations. Conditional statements can also be tested before output results go to target tables.
What do you mean by Enterprise Data Warehousing? What is target load order? Where can we find the throughput option in informatica? What is the use of target designer? What do you mean by worklet? What are the different types of OLAP? Give an example? What is OLAP (On-Line Analytical Processing? Tell me any other […]
Command task can be called as the pre or post session shell command for a session task. One can run it as pre-session command r post session success command or post session failure command.