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 |
what is informatica metadata?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
Why we use stored procedure transformation?
what are presession,postsession success and postsession failure commands ?
what is the process we used in joiner transformation,there is no matching column in sources?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
what is junk dimension
How many numbers of sessions can one group in batches?
What is substr in informatica?
in oracle write query yourname+1 from dual
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?