Answer Posted / rudresh

Transformation is a repositorty object,which loads the data
into target as per the busines rule.

Transformations are two types
1)Active
2)Passive

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2178

---

Explain how many types of dimensions are available in informatica?

1165

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1014

---

can we override a native sql query within informatica? How do we do it?

1180

---

What are the types of data warehouses?

1568

---

How to create Target definition for flat files?

1275

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2195

---

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2156

---

How to create a non-reusable instance of reusable transformations?

1166

---

How can you differentiate between powercenter and power map?

1134

---

What are different types of transformations available in informatica?

1054

---

What the difference is between a database, a data warehouse and a data mart?

1196

---

Define joiner transformation?

1097

---

How do we call shell scripts from informatica?

1186

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2120

---