Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7112 Views
- GE, I also Faced
- E-Mail Answers
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 |
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
Explain about perform recovery?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Why is sorter an active transformation?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
What is joiner change?
What are the Advantages of de normalized data?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
My source table having some records ,i want load 1st record and last record into one target?
What is a filter transformation?
What are active and passive transformations?
Teradata 
