Answer / raghu ram

search in youtube you can find installation videos search as
"informatica installation"

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

---

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  

---

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

Explain the use of aggregator cache file?

0 Answers  

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

---

what is constraint based load order

2 Answers   Cap Gemini,

---

What is the fact table?

0 Answers  

---

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

---

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

---

Explain the informatica workflow?

0 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---