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,

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

what is session override?

2 Answers   Cap Gemini,

---

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

---

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

---

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

What are batches?

0 Answers  

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---