Informatica Interview Questions And Answers_Part 1

1. How to get UNIQUE Record?

S-SQ-SRT-EXP-FLT OR RTR – TGT

In Expression:

flag = Decode(true,eid=pre_eid, 'Y','N')

flag_out = flag

pre_eid=eid


2. How to get sequence value using Expression?

v_temp= v_temp+1

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?

Answer:

Using RegMatch in Informatica to validate

IIF(reg_match(in_Email,'^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$'),'Valid','Invalid')

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

Example:1

select

case snum

when snum > 10 then 'High'

when snum>5 then 'Low'

end

from sales..

Ex:2

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.

 Ex: Emp_id.