Informatica - can anyone please explain how i can write a subquery in the expression editor of a filter transforma

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 70 of 327

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)

thanks
nayana

Total Answers and Comments: 4

Last Update: July 10, 2009 Asked by: nayana

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 08, 2006 03:47:34

pratibha

informatica

maping level coding in informatica

Is this answer useful? Yes | No

September 08, 2006 09:45:27

nayana

RE: can anyone please explain how i can write a subque...

can you explain in that in a nutshell

thanks

nayana

Is this answer useful? Yes | No

September 12, 2006 09:37:53

Motilal

Member Since: June 2006 Contribution: 13

RE: can anyone please explain how i can write a subque...

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..

Is this answer useful? Yes | No

July 10, 2009 10:23:27

sreenivasareddy.aug10

Member Since: July 2009 Contribution: 2

RE: 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

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank