Difference between session variables and workflow variables?
Answers were Sorted based on User's Feedback
Answer / jlt
A workflow variable can be used accross sessions inside
that workfow..whereas a session variable is exclusive only
for that particular session
| Is This Answer Correct ? | 20 Yes | 0 No |
Answer / nithin
Also,workflow built in variables enable the workflow to determine the run flow of sessions. eg) If a decision is set to true one set of sessions are processed and if it is false the other set of sessions are processed. Where as the session's user defined or built in variables focuses on getting the start time of the session, to get the table and mapping name. The task variables helps to get the information about the sessions
| Is This Answer Correct ? | 1 Yes | 0 No |
What is meant by lookup transformation?
In any project how many mappings they will use(minimum)?
What is junk dimention?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
How to generate or load values in to the target table based on a column value using informatica etl tool.
with out using update strategy transnsformation how to update the data in mapping level
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
How can u stop a batch?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?