S-SQ-SRT-EXP-FLT OR RTR – TGT
flag = Decode(true,eid=pre_eid, 'Y','N')
flag_out = flag
2. How to get sequence value using Expression?
o_seq=IIF(ISNULL(v_temp), 0, v_temp)
3. How will restrict values in 0-9, A-Z, a-z and special character. Only allowed these chars otherwise we will reject the records?
Using RegMatch in Informatica to validate
4. What is diff between Decode and case? Give some Example?
In case, you can use logic as >, <, <=,>= , whereas in decode you can only use =.
when snum > 10 then 'High'
when snum>5 then 'Low'
select decode(snum,10,'high',5,'low') from sales...
5. What is the difference between bitmap and btree index?
Bitmap index is used for repeating values.
Ex: Gender: male/female
Account status: Active/Inactive
Btree index is used for unique values.