Can anyone please explain how i can write a subquery in the expression editor of a filter transformation (i need the syntax to write in the expression editor)thanksnayana

  • Interview Candidate
  • 6
  • 4139

Showing Answers 1 - 6 of 6 Answers

pratibha

  • Sep 8th, 2006
 

maping level coding in informatica

  Was this answer useful?  Yes

nayana

  • Sep 8th, 2006
 

can you explain in that in a nutshell

thanks

nayana

  Was this answer useful?  Yes

Motilal

  • Sep 12th, 2006
 

The subquery syntax is very similar to SQL.

Still, you can see the navigator page in the left side of the editor page.

we have ports,functions, etc there.

you can double click on a fuction to find that funtion in your editor page.And the logic must be from you as obvious..

  Was this answer useful?  Yes

sreenivasareddy.aug10

  • Jul 10th, 2009
 

You could not write the subquery in Filter editor. Because Filter editor is for specifying the conditions only. You can write the  subqueries in by source qualifier. There you can use the filter condition as well as write the subquery and overide SQL you can archive.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions