How do you implement scheduling in Informatica?
We can use Scheduler option in Workflow to schedule the entire mapping.
Also, if we are using any central scheduler tool for this purpose, we can create a command file with PMCMD to run the workflow and schedule execution of that command file in a scheduler.
| Is This Answer Correct ? | 2 Yes | 0 No |
How to generate sequence numbers?
connected and unconnected lookups?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
What is workflow? What are the components of workflow manager?
Partition, what happens if the specified key range is shorter and longer
what are the unix commands to start the wrk flow ?
In development project what is the process to follow for an etl developer from day1
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??