Answer / vivekk

Informatica is a Service Oriented Architecture, which means it has Client component and Server component.

In order to start the server, we need to start the services first. Lets see about the Server in regards with this question.

The server stores the meta data and not the actual data. It has Repository and Integration services. The Server components has multiple Domain and Node.

Each Node has those Repository and Integration services.

Repository services are used to design the code
Integration services are used to execute the code.

What is DR strategy for Informatica project?

0 Answers  

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

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

2 Answers  

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

What is A cache?

2 Answers  

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

---