Answer Posted / murali vishnuvajhala

Apologies for giving wrong answer in the past (Answer #4)

You can actually join multiple tables in the lookup.
Here are the steps.
1. Click on Lookup transformation
2. Click on "Skip" button to the right
3. A green Lookup Transformation will apprear without any
ports.
4. Put your query in the SQL Override.
5. Make sure you specify the columns you selected in your
query as ports IN THE SAME ORDER
6. Your lookup is ready

NOTE: When you specify the query make sure you specify
column alises for each column.... else you will get invalid
lookup error during run time.

Good Luck!

r u done any partitions in ur project?

1832

---

What are the differences between oltp and olap?

978

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1086

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2087

---

What is union transformation?

971

---

What are the tuning techniques you applied during your last project

2036

---

What are the types of data warehouses?

1529

---

What is decode in static cache?

1188

---

Under what condition selecting sorted input in aggregator may fail the session?

1131

---

What the difference is between a database, a data warehouse and a data mart?

1159

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7409

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1178

---

What is aggregator transformation in informatica?

960

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2131

---

What are the advantages of using informatica as an etl tool over teradata?

1030

---