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 is a time dimension? give an example?
What do you mean incremental aggregation?
What is aggregate cache in aggregator transforamtion?
Is stop and abort are same in informatica?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
How to improve the performance of Aggregate transformation?
where to store informatica rejected data?
What are parallel querys and query hints?
Three date formats are there . How to change these three into One format without using expression transformation ?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.