Answer Posted / lakshmi

Granularity defines the extent of details

Example:Let us look at geographical level of granularity.We may analyze data at the levels of country,region,territory,city and street.In this case,highest level of granularity is street.

what is the difference steps for data modeling?

2199

---

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2273

---

Can u access a repository created in previous version of Informatica?

1902

---

Mention few test cases and explain them?

980

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1839

---

Is hadoop a etl tool?

1000

---

how do u identify the changed records in operational data?

2588

---

What is data modeling and data mining?

1018

---

Explain what are the various etl tools in the market?

987

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

1025

---

where are the log files generally stored.Can you change the path of the file.what can the path be?

2493

---

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

2045

---

what are the types in error loging?

2192

---

Explain etl mapping sheets?

1125

---

What is etl process? How many steps etl contains?

1081

---