Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,

---

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

---

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  

---

What are the new features of informatica 9 version?

2 Answers  

---

what is dynamic insert?

0 Answers  

---

What are the three tiers in etl?

0 Answers  

---

explain the methodology of Data Warehousing?(Polaries)

0 Answers  

---

working of line item dimension......pls,tell overall flow

1 Answers  

---

When do we analyze the tables?

0 Answers  

---

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,

---

how do u handle performance issues in Informatica . where can u monitor the performance ?

0 Answers  

---

what is the difference between cardinality and Nullability?

0 Answers  

---