how to run 2 workflows sequentially. plz respond what is the
process?
Answer Posted / vijay reddy
We can do using Event Raise & Event Wait tasks in workflows
| Is This Answer Correct ? | 17 Yes | 20 No |
Post New Answer View All Answers
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain load alternative records / rows into multiple targets - informatica
explain abt ur project architecture?
What is a passive transformation?
What is meant by target load plan?
explain about unit testing? in real time?
How to handle decimal places while importing a flatfile into informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain sessions and how many types of sessions are there?
Tell me about MD5 functions in informatica
What are the components of the workflow manager?
Explain sessions?
Suppose we do not group by on any ports of the aggregator what will be the output?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.