Answer / nagaraju bhatraju

www.esnips.com/web/InformaticaDumps

www.esnips.com/web/InformaticaAdminstrationCertificationPape
r

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

---

What is junk dimention?

3 Answers   Patni,

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

what transformations are used for Variable port?

2 Answers  

---

How can we create index after completion of load process?

0 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---