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 |
Explain in detail scd type 2 through mapping.
what is unique constraint error ?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
Name 4 output files that informatica server creates during session running?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Briefly define reusable transformation?
scd methodology?
how to design mapping half of source table records into one target and remaining half into another target
What is up date strategy and what are the options for update strategy?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
WHAT IS FACT TABLES?