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 |
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
explain different types of modeling.
server hot-ws270 is connect to Repository B. What does it mean?
Is it possible to update the target table with PK?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
How to load last 10 records of flat file in to the target?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
What is staging area?
what is diff between grep and find
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?