Answer Posted / mohammed

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

What is joiner transformation in informatica?

1045

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1016

---

What if the source is a flat-file?

1112

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

---

What is informatica? Why do we need it?

1101

---

What are the differences between a connected lookup and unconnected lookup?

1070

---

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

1155

---

waht type of interface is used for testing the data in informatica

2258

---

What is rank transformation?

991

---

what are the Methods For Creating Reusable Transformations?

1175

---

What is an Integration service in Informatica?

1136

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1012

---

How big was your fact table

1803

---

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.

2201

---

Enlist the tasks for which source qualifier transformation is used.

1040

---