Can we schedule a workflow(not a session) to run after
completition of another workflow? Can we make a workflow
depend on completition of another one?
Answers were Sorted based on User's Feedback
Answer / santosh kumar sarangi
Different type of scheduler are there in market for this
purpose like WLM(Work Load Manager), Control M.
If you want to do it through informatica then after
completion of all the session of first work flow keep
command task and with in the command task call the next work
flow through pmcmd command.
Let me know if i am wrong.
Santosh Kumar Sarangi
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jack patel
yes,we can schedule a 1workflow after 2 workflow make a dependent on first one.
ex: if we have 5 workflow and we want to schedule a job in production. just do dependent on previous one..
| Is This Answer Correct ? | 1 Yes | 0 No |
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
What is a node in Informatica?
how to load only the first and last record of a flat file into the target?
define galaxy repository in informatica
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
How many joins in Informatica
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
How to load query faster,so that It will take less time to load?
How will you check the bottle necks in informatica? From where do you start checking?
When will you use SQL override in a lookup transformation?