What are the session parameters?
Answers were Sorted based on User's Feedback
Answer / swetha
Session parameters r like maping parameters,represent values
U might want to change between
sessions such as database connections or source files.
Server manager also allows U to create userdefined session
parameters.Following are user defined session parameters.
Database connections
location of Source file names: use this parameter
when u want to change the name or
session
source file between session runs
location of Target file name : Use this
parameter when u want to change the name or
session
target file between session runs.
location of Reject file name : Use this
parameter when u want to change the name or
session
reject files between session runs.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / sanjay
Hi Swetha,
Your answer is precisely correct but i want to point out
here if we can change the the session parameter value
during session run then what are session variables for. I
guess session parameter values cannot be changed during
session runs.
Is This Answer Correct ? | 4 Yes | 5 No |
Answer / venkat
A session parameter defines a connection to a file system.
Is This Answer Correct ? | 1 Yes | 2 No |
How many ways are there to create ports?
How to load last 10 records of flat file in to the target?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
how can we run workflow with pmcmd?
What is confirmed dimension?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
From where we can start or use pmcmd?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Which one is better performance wise connected/un-connected lkp?why?
How do you create single lookup transformation using multiple tables?
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
how to connect two or more table with single source qualifier?