Answer / swetha

Join data originating from same source data base.

Filter records when the informatica server reads source data.

Specify an outer join rather than the default inner join

specify sorted records.

Select only distinct values from the source.

Creating custom query to issue a special SELECT statement
for the informatica server to read source data.

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

what is session override?

2 Answers   Cap Gemini,

---

What is dynamic cache?

0 Answers  

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

---

What are the measure objects?

0 Answers  

---

.prm wirh repalce .txt is possible?

2 Answers  

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

How to use procedural logic inside infromatica?

0 Answers  

---

What is complex mapping?

0 Answers  

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---