Answer Posted / suneelkumar.dasari

If u want to use the same look up T/R more than one time,you should use compulsory Unconnected lookup.A common use for unconnected Lookup transformations is to update slowly changing dimension tables.I know these 2 uses.

Differentiate between a database and data warehouse?

1090

---

What are the different components of powercenter?

986

---

How to update or delete the rows in a target, which do not have key fields?

1116

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1047

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1908

---

What does refresh system mean, and what are its distinctive choice?

1072

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4677

---

Enlist the advantages of informatica.

1005

---

Define the various join types of joiner transformation?

941

---

What is update strategy transform?

1015

---

What are the differences between source qualifier and joiner transformation?

993

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1730

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5683

---

Scheduling properties,whats the default (sequential)

1891

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2468

---