Difference between session variables and workflow variables?
Answer Posted / 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 |
Post New Answer View All Answers
What is a transaction control transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the informatica performance improvement tips
What is dynamic cache?
Parameter and variable differences
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is powercenter on grid?
What is informatica etl tool?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
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.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the types of schemas we have in data warehouse and what are the difference between them?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab