Answer Posted / ramesh

the main difference between connected and unconnected is

connected:
recieves data from source table in a pipeline.
it returns multiple columns
it supports user defined default values
unconnected:
recieves data from result of the lookup expresion on other transformation
it returns one column
it doesnt supports use defined default values

Explain the informatica workflow?

1127

---

What is data caches/ index caches?

1171

---

explan ur project architecture?

2126

---

Explain informatica architecture - version 8 / 9

1151

---

What is a snowflake schema?

1047

---

How many numbers of sessions can one group in batches?

1101

---

What is a mapplet/worklet in informatica?

1244

---

What is decode in static cache?

1261

---

Explain sessions?

1140

---

What is a rank transform?

1146

---

How you prepared reports for OLAP?

1658

---

What is the difference between a repository server and a powerhouse?

1577

---

How many input parameters can exist in an unconnected lookup?

1600

---

What is the function of aggregator transformation?

1135

---

Explain the pipeline partition with real time example?

1200

---