Answer Posted / venky

select * from emp e where &n=(select count(distinct(b.sal))
from emp b where e.sal=b.sal);

How many types of sessions are there in informatica.please explain them?

1132

---

What are active and passive transformations?

1041

---

what is INFORMATICA TESTING process

2250

---

Write the program through which the records can be updated?

961

---

What is a joiner transformation and why it is an active one?

1025

---

Explain the tuning lookup transformation - informatica

967

---

can you please explain me pre session and post session options?

7462

---

How to differentiate between the active and passive transformations?

1104

---

What are the types of presistent cache in look up tr.

2028

---

What are the guidelines to be followed while using union transformation?

1095

---

What is meant by a domain?

1096

---

which one is better performance wise joiner or look up

1041

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1962

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2091

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1823

---