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 the difference between bitmap and btree index?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
what is the difference between informatica6.1 and infomatica7.1
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
What are the components of the workflow manager?
What are the new features of the server manager in the informatica 5.0?
What is the difference between Bulk Load and Normal Load
with out using update strategy transnsformation how to update the data in mapping level
How we will implement Pushdown Optimization and Types in Informatica with better examples
Do you have to change the reject file b4 using reject loader utility.
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,