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 the difference b/w natural key and surrogate key
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is option by which we can run all the sessions in a batch simultaneously?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
In real time scenario where can we use mapping parameters and variables?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
What the difference is between a database, a data warehouse and a data mart?
what is the difference between copy object import objects using repositery manager which one is best
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram