Answer / ahalya inturi

constraint based load order defines the order in which data
loads into the multiple targets based on primary key and
foreign key relationship.

Answer / chandrasekar

The above answer with add one point we can configure the
constraint based load order in the Session Config obj tab.

what transformations are used for Variable port?

2 Answers  

---

What is mapplet in informatica?

0 Answers  

---

What is a node in Informatica?

0 Answers  

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

Explain the different dimensions.

0 Answers  

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

---

Describe an informatica powercenter?

0 Answers  

---