Answer / mike

well informatica is the tool used for data aquisition
process..which is nothing but data extraction, data
transformation and data loading. Inorder to build a data
ware house we use informatica
or
It is a GUI tool and we need informatica for
running,designing,monitoring and administrating the data
flow from various external source and internal sources to
the data ware house

correct me if i was wrong

Answer / deepthi

etl's r of 2 types.code based n gui based.in code based etl
we have some limitations.inorder 2 over come those
limitations we use gui based etl ninformatica is 1 among
the gui.

performance wise which one is better in joiner and lookup transformation

2 Answers  

---

How do you set a varible in incremental aggregation

0 Answers  

---

what is difference between mapping and mapplet ?

2 Answers   TCS,

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

How does a sorter cache works?

0 Answers  

---

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

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

1 Answers  

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

What is a data modeling?

2 Answers  

---