can we have to do changes in session property when we are dynamically generating target files?
Answers were Sorted based on User's Feedback
Answer / priyank
Use Transaction Control Transformation to generate target
files dynamically. While importing the target file, a button
"F" is present in the last on top right. Clicking that, a
port "FileName" is created of size 255.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shalaka
Yes, we have to give Db Connection information in session property
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / dhanasekar
Yes we can make changes in the session property. IT is only flat file names for dynamic file creation and we can create it using TCT and in the session properties we can give the destination folder.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the mapping parameters and mapping variables?
can anyone explain me about retail domain project in informatica?
What is power center repository?
What is the difference between Bitmap and Btree index?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
how to improve performence by using sorted input in aggrigator t/r.
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
How we will implement Pushdown Optimization and Types in Informatica with better examples
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
I have a flat file, want to reverse the contents of the flat file
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
How do you recover rows from a failed session