Answer / nitin

1) we can not perform PDO if we are using variable ports and informatica inbuilt functions.
2) If we have source and target on the different schema we can not go for full PDO, in this case either we have to go for source PDO or Target PDO.

Answer / rao

1)We can not apply push down optimization if mapping contain
aggregate transofrmation.

2)When we implement p.optimization ,the integration services
send logic to databases.because of this wa can not capture the
rejected records in reject file.

Answer / chandu

we can't implement for aggregator tranformation
we cant implement for master source in joiner transformation

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

---

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

---

How would you join a node to the already existing domain?

0 Answers  

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

---

What are the active and passive transforamtions?

2 Answers  

---

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---