How do schedule a workflow in Informatica thrice in a day?
Like run the workflow at 3am, 5am and 4pm?
Answers were Sorted based on User's Feedback
Answer / saidgrd
In workflow designer > workflow > schedulers ... you can set
3 different daily schedulers. Each one has its execution
time (3, 4, 5 pm)
Regards,
Saïd
Is This Answer Correct ? | 7 Yes | 8 No |
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is the difference between stop and abort
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
How do you load first and last records into target table?
What is a filter transformation?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
How do we call shell scripts from informatica?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
In which circumstances that informatica server creates Reject files?