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 the facts will be loaded? explain
How to delete the (flat file) data in the target table after loaded.
can we override a native sql query within informatica? Where do we do it?
What is a difference between complete, stop and abort?
whats the logic to load the lower level of granularity of data to fact table.
how to convert the .doc docs into .txt format using informatica
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
why we use datawarehouse
Define sessions in informatica etl?
What is domain and gateway node?
During the running session, output files are created by informatica server. Enlist few of them.