What are the measure objects?

0 Answers  

---

Insert else update option in which situation we will use

4 Answers   HCL,

---

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,

---

What is different between the data warehouse and data mart?

0 Answers  

---

Which development components of informatica have the highest usage?

0 Answers  

---

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   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  

---

in which situations do u go for snowflake schema ?

2 Answers   TCS,

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

Different circumstance which drives informatica server to expel records?

0 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---