can we have to do changes in session property when we are dynamically generating target files?
- 3 Answers
- 8261 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the cumulative sum and moving sum?
What is parallel processing in informatica?
What is joiner transformation in informatica?
How to load last n records of file into target table - informatica
What is the different lookup cache(s)?
can you please explain me pre session and post session options?
What is meant by a domain?
Define enterprise data warehousing?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain the use of aggregator cache file?
Briefly describe lookup transformation?
What do you mean by channel change?
What is a router transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
