Answer Posted / guest

Hi,

Use the lookup on emp table .Override the lookup Query
(select min(sal) from emp. Connect the empno port and min
(sal) port to exp. Fetch all the rows from emp table to
exp, then connect to filter give condition sal> min(sal).

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1133

---

How to convert multiple rows to single row (multiple columns) in informatica

1384

---

What you know about transaction control transformation?

996

---

Explain the scenario which compels informatica server to reject files?

1171

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8124

---

What is rank transform?

1000

---

What is sorter transformation?

1050

---

Performance tuning in UNIX for informatica mappings?

2570

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1066

---

what is the size of your data warehousing?

2096

---

Please let me know how to make Data masking in informatica..

1729

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1071

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1797

---

What is aggregator transformation in informatica?

953

---

How to go to the older version for a mapping?

1100

---