February 21, 2023 at 1:02 pm
I'm newbie using Informatica Data Quality Analyst and am unable to create a basic SQL statement.
The Sql query is being created against a mapping specification of a table that was imported as a flat file originally. The statement is as follows:
Select ColumnA, ColumnB FROM Table1
WHERE Table1.ColumnA = 'S'
That SELECT.... FROM part of the statement works well, but when I add the WHERE clause, I get issues. After reading this blog, I believe my statement is conventional SQL, so I'm not sure why this won't work. Is it true that Informatica Analyst only accepts SQL in a certain format? Are there any issues with the inverted commas?
February 21, 2023 at 1:07 pm
Probably one to go and read the documentation on how to use Informatica, but looks like you don't use the ' on the value in the where
Hope this is the right product you are using here to validate what you are doing.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy