What are the session parameters?
- 3 Answers
- 14558 Views
- I also Faced
- E-Mail Answers
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 |
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
what is the necessity to use update strategy?(except for updates)
sample mappings for scd1,scd2 and scd3
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
what is workflow varible
How do we call shell scripts from informatica?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
explain different levels in pushdown optimization with example?
plz plz plz send client names and project names in informatica?
Explain transaction control transformation in informatica
How do you convert single row from source into three rows into target?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
Teradata 
