Answer / maruthi

ys we can clean data by using informatica upto a extent,by
using expression transformation by using below varaibles
1.)ltrim,rtrim,ifnull,isnull,such so many fn u can get in
transformation

Answer / birendra

Yes we can clean data by using informatica through
expression transformation

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  

---

flat filevalidation in informatica

0 Answers   Hewitt,

---

How to fine tune mappings?

0 Answers  

---

What is ROWID explain ?

2 Answers   Wipro,

---

what is the difference between OLTP database and data warehousing database?

3 Answers  

---

what is HISTOGRAM? how to generate statistics?

1 Answers  

---

What is grain of fact?

0 Answers  

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 Answers  

---

what are the parts of Informatica server ?

1 Answers   GE,

---

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

---

we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 Answers  

---

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,

---