Answer Posted / shashiall
may b it is the path where our flat file is residing.we
have to give the total path at the place of the file
list...
plz...correct me if am wrong...
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What are the steps involved in the migration from older version to newer version of Informatica Server?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are data-driven sessions?
What are connected or unconnected transformations?
Explain informatica architecture - version 8 / 9
What are the components of Informatica? And what is the purpose of each?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain the etl program with few examples.
Differentiate between router and filter transformation?
To import the flat file definition into the designer where should the flat file be placed?
What is data movement mode in Informatica and difference between them?
How to convert multiple rows to single row (multiple columns) in informatica
can we override a native sql query within informatica? How do we do it?
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.
