Answer Posted / giri

Schema is structure of information

1.STAR SCHEMA
-------------
Centralized Fact table connect the one or more denormalized data

2.SNOW FLAKE SCHEMA
-------------------

Centralized Fact table connect the one or more normalized data

3.STAR FLAKE SCHEMA
-------------------

One or more centralized fact table connect the single denormolized data

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1315

---

How many ways are there to create ports?

1403

---

What is a filter transformation and why it is an active one?

1015

---

What is the difference between informatics 7x and 8x and what is latest version?

1137

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1170

---

What is the different lookup cache(s)?

1129

---

What is a standalone command task?

1256

---

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.

2901

---

What is dimensional table?

1131

---

what is size of u r database?

2365

---

What are junk dimensions?

1111

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282

---

What are the types of schemas we have in data warehouse and what are the difference between them?

986

---

What is the function of look up transformation?

1174

---

What are different types of transformations available in informatica?

1058

---