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 |
In a table, 4 person having same salary. How to get Third person record only?
What is the use of code page?
what is diff between IN and EXIT commands
When will you use SQL override in a lookup transformation?
What is persistent lookup cache?
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
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is meant by lookup transformation?
Is it possible to update the target table with PK?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
why normalizer transformation can not used in mapplet? plzzzz answer
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?