Informatica SQL generating basic statement

• Piyushbhatt

  Old Hand

  Points: 374

  More actions

  February 21, 2023 at 1:02 pm

  #4152292

  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?

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  February 21, 2023 at 1:07 pm

  #4152293

  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

   

  https://docs.informatica.com/data-quality-and-governance/informatica-data-quality/10-4-0/application-service-guide/data-integration-service-rest-api/queries/where-clause.html

   

  Hope this is the right product you are using here to validate what you are doing.