Answer / earfgwerf

For more Informatica Interview Questions Click Here

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---

What are the different types of schemas?

11 Answers   ITC Infotech,

---

Does an informatica transformation support only aggregate expressions?

0 Answers  

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

Explain about Recovering sessions?

1 Answers  

---

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

Briefly describe lookup transformation?

0 Answers  

---