Answer / vanita

For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

---

How does the aggregator transformation handle null values?

0 Answers  

---

in static and dynamic which one is better

2 Answers  

---

---

What are the various types of transformation?

0 Answers  

---

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

What is a data modeling?

2 Answers  

---

connected and unconnected lookups?

4 Answers  

---

What is mapplet in informatica?

0 Answers  

---