Answer / sunil

Data Mart is subset of enterprise datawarehouse which
supports bussiness needs of middle level management in an
enterprise.

datamart is designed for particular line of business,such
as sales,marketing and finance
DW is maitaining the total organization of data
where as DM is maitained only particular subject.

Answer / sujana

data mart is a particularsubject unlike dwh..for ex
totla organization data --dwh
sales,marketing etc--data mart

Answer / tom

Adding to Sunil's answer- Data Mart is a object oriented and
DW is a subject oriented

Answer / vali

hi guys iam adding one more point...
data mart is designed for business transcational process
where as dwh desgined for business analysys

any modifications plz let me kw..vali
vali413@gmail.com

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

---

how to sort date field in infomatica?

2 Answers  

---

What are the different threads in DTM process?

2 Answers  

---

generate Unique sequence numbers for each partition in session with Unconnected Lookup ? Hi All, Please help me to resolve the below issue while Applying partitioning concept to my Session. This is a very simple mapping with Source, Lookup , router, and target. I need to Lookup on the target and compare with the source data, if any piece of data is new then Insert, and If any thing change in the existed data then Update. while Inserting the new records to the target table I'm generating sequence numbers with Unconnected lookup, by calling the maximum PK ID from the target table. The above flow is working fine from last one year. Now I wish to apply the Partitioning concept to the above floe(session) At source I used 4 pass through partitions.(For Each partition different filter conditions to pull the data from source) at Target I used 4 passthrough Partitions. it is working fine for some data, but for some rows for Insert Operation , it is throwing Unique key errors, because while Inserting the data it is generating the same sequence key twice. In detail : 1st row is coming from 1st partition and generated the sequence number 1 for that row. 2nd row is coming from 1st partition and generated the sequence number 2 for that row 3rd row is coming from the 2nd partition generated the sequence number 2 again for that row. (it must generate 3 for this row) the issue is becuase of generating the same sequence numbers twice for different partitions. Can any one Please help me to resolve this issue. While Applying partitions how can I generate a Unique Sequence numbers from Unconnected lookup for Each partitioned data. Regrads, N Kiran.

2 Answers   Tech Mahindra,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

Differentiate between router and filter transformation?

0 Answers  

---

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

---

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

---

WHAT IS FACT TABLES?

2 Answers  

---

can any one explain me about junk dimension

4 Answers  

---

What is a parameter When and where do you them when does the value will be created

0 Answers  

---