Answer Posted / krishna

in starschema the fact is denormalised ...all dimension
tables are normalise..there will be primary foreignkey
relation ship between fact and dimension tables.
for better perfomance we use starschema when compare to
snow flake schema ..where fact table and dimension tables
are normalised...for every dimension table tthere will be a
look table ..we have to dig from top to bottom in the
snowflake schema.

what is unit testing?tell me proceedure

2163

---

What are different types of transformations available in informatica?

934

---

What is repository manager?

927

---

What is expression transformation?

1032

---

What is event and what are the tasks related to it?

1051

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1439

---

Explain constraint based loading in informatica

1033

---

Briefly describe lookup transformation?

982

---

Differences between connected and unconnected lookup?

1119

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2795

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1216

---

What is an expression transformation in informatica?

958

---

How to start a workflow using pmcmd command?

1169

---

How do you take back up of repository?

1092

---

What is Session and Batches?

1039

---