top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Sql case statement

0 votes
34 views

Sql case statement is selecting the records but not returning the conditions in informatica

ex. Select *,case if emp_de = 'M' and leave is not null then 'Yes',when if emp_de = 'M' and leave is null then 'No' As 'Remark' end from EMP table where emp_Sal <2000.
the query is working fine in the informatica but the condition Yes or No not updating in the Remark port.

posted Jan 10 by Jaisee Lan
Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

Your answer

Preview

Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.
Similar Questions
0 votes

Sql case statement is selecting the records but not returning the conditions in informatica

ex. Select *,case if emp_de = 'M' and leave is not null then 'Yes',when if emp_de = 'M' and leave is null then 'No' As 'Remark' end from EMP table where emp_Sal <2000.
the query is working fine in the informatica but the condition Yes or No not updating in the Remark port.

+1 vote

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I am unable to find any good examples on the syntax.

I would really appreciate if anyone could give me some specific examples on how to use case statements/decode function in Informatica.

Thanks much for your help!

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...