How to load the data from a flat file into the target where the source flat file name changes daily?
No Answer is Posted For this Question
Be the First to Post Answer
What are the basic needs to join two sources in a source qualifier?
What is a test load?
Types of error logs in Informatica?
what are objects in data warehouse?
What is source qualifier transformation in informatica?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
can u any challenge your project?
How You Pull the records on daily basis into your ETL Server.
In which scenario did u used Mapping variable?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
waht is dataware house
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.