Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

---

How do you load only null records into target?

0 Answers  

---

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

---

who to split dimentions into sub dimention

3 Answers   Wipro,

---

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

what is the difference between lookupoveride and joiner?

3 Answers  

---

how you will maintain version?

3 Answers   CTS, TCS,

---

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---