in flatfile target how can u create header and footer plese
give me the comands how will u write in session properties
Answer Posted / teja_dwh
by using session properties we can create header and footers
for flat file.
we can take column names as header etc.
reply me if am wrong
teja_dwh@yahoo.com
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to generate sequence numbers using expression transformation?
What are the restrictions of union transformation?
Explain informatica architecture - version 8 / 9
scenario where i can use only concurrent execution of workflow.
What are the different options available for update strategy?
Explain Dataware house architecture .how data flow from intial to end?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Whats there in global repository
What is an unconnected transformation?
What is substr in informatica?
What is informatica powercenter repository?
How to start a workflow using pmcmd command?
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.
can we override a native sql query within informatica? Where do we do it? How do we do it?