Answer Posted / pradosh

yes,it is similar to oracle IN function

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1733

---

What is an unconnected transformation?

855

---

Performance tuning( what you did in performance tuning)

1703

---

Please let me know how to make encryption and decryption with example?

1670

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

811

---

How to extract sap data using informatica?

787

---

How does the aggregator transformation handle null values?

912

---

how many types of dimensions are available in informatica?

743

---

What is a dimensional model?

737

---

EXL informatica Questions

1130

---

What are the reusable transformations?

870

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1395

---

How can a transformation be made reusable?

842

---

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

1630

---

How to create the source and target database connections in server manager?

812

---