Answer / srinu

unonnected lookup

Answer / ankit kansal

Unconnected Lookup is a better option as It will fire a sequel query whenever it was being called from other transformation using :LKP.lkp_trans(fieldname).

Or

Create a persistence cache for that table if it's not getting updated frequently. and use this cache in different other jobs.

http://deepinopensource.blogspot.in/

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

How can you differentiate between powercenter and power map?

0 Answers  

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---