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 |
How are parameters defined in informatica?
how will you get 21 to 30 record from 50 records?
how remove 1st 3 records & last 3 records in informatics
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
What is the difference between IN and Exists in Oracle?
How to improve the performance of Aggregate transformation?
What are the features of complex mapping?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
How can we use mapping variables in informatica? Where do we use them?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.