Answer / Ravi Krishnan

Lookup Transformation is a transformation type in Informatica that allows you to extract data from a source qualified table or view and map it to a target qualified table or view. Here's an example of how to create a Lookup Transformation using Informatica PowerCenter:n
1. Open Informatica PowerCenter and create a new Integration Service.
2. Add a source qualifier for the source table or view that you want to use as your lookup table.
3. Create a transformation where you will add a Lookup Transformation.
4. Drag and drop a Lookup Transformation from the palette onto the canvas.
5. Configure the Lookup Transformation by specifying the source and target tables, and setting any necessary options such as matching behavior and sort order.
6. Add a target qualifier for the target table or view that you want to update with the lookup data.
7. Connect the input and output ports of the Lookup Transformation to the appropriate sources and targets.
8. Save and run your Integration Service.

What are the different types of transformation available in informatica.

1 Answers  

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1 Answers   IBM,

---

What are differences between Informatica 7.1 and 6.1

3 Answers  

---

What are the types of schemas we have in data warehouse and what are the difference between them?

1 Answers  

---

What is the Hierarchy of DWH?

1 Answers  

---

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

---

What will be the approach?

1 Answers  

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1 Answers   IBM,

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1 Answers   TCS, Wipro,

---

How to configure mapping in informatica?

1 Answers  

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---