can we have to do changes in session property when we are dynamically generating target files?
- 3 Answers
- 9235 Views
- Wipro, I also Faced
- E-Mail Answers
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 UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
what is casual dimension?
Design time, run time. If you don't create parameter what will happen
If u select groupby port in aggregator what is output and dont select groupby option what is output
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
what is confirmed fact?
how do u tune queries?
How do you load first and last records into target table?
what is the gap analysis?
Explain about Informatica server process that how it works relates to mapping variables?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is the purpose of surrogate key and diff between primary key&surrogate key
Teradata 
