Answer / priyank

There are some keys which are present in the fact table but
they do not have a corresponding Dimension table related to
them. These are called Degenerated Dimensions.

Eg. Transaction No., Invoice No.

what is diff between grep and find

3 Answers   IBM, iFlex,

---

guys which is the best institute in banglore to learn informatica??

2 Answers  

---

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

---

What could be the possible resons of locks by user?

0 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

what is target update override and when we use it?

2 Answers   TCS,

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

What is persistent lookup cache?

0 Answers  

---