Answer Posted / mohammed

Snowflake is an extension of star schema, where star schema
with each dimension is typically stored in one table.

what is the hint? how to use it to reduce the query processing in program?

7966

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2085

---

How can we use batches?

1062

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2248

---

How can one identify whether mapping is correct or not without connecting session?

1493

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1951

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2323

---

Explain scd type 3 through mapping.

1051

---

Where are the source flat files kept before running the session?

1137

---

Explain why we use partitioning the session in informatica?

1161

---

What is InformaticaPowerCenter?

1177

---

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

1111

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2309

---

Difference between Data and Index Caches?

1198

---

State the limitations where we cannot use joiner in the mapping pipeline?

1105

---