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 difference between mapping and mapplet ?
What are the basic needs to join two sources in a source qualifier?
what is parallel querying and what r hints.
what is the predefined port in dynamic lookup
Why we use stored procedure transformation?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
Which is the t/r that builts only single cache memory?
How do you load only null records into target? Explain through mapping flow.
What is diff joiner and lookup
Enlist the differences between database and data warehouse.
How do you update the records with or without using update strategy?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools