Answer / amedela chandra sekhar

Data mart is a subset of data ware housing.it is a complete
information about one particular domain.

ex:finance,hr,sales.....





chandumba2005@gmail.com

Answer / nagendra phani

Data Mart is the subset of datawahehouse and it is used to
store the data department wise.

Answer / sivaram

A DATA MART IS A SUB-SET OF AN ENTERPRRISE DATAWAREHOUSING.
A DATA MART IS ASUBJECT ORIENTED DATA BASE WHICH SUPPORTS THE
BUSINESS NEEDS OF INDIVIDUAL DEPARTMENTS WITHIN THE
ENTERPRISE.
A DATA MART IS ALSO KNOWN AS HIGH PERFORMENCE QUERY
STRUCTUERS.

Answer / anand

For overwriting Data.Ex" we used to load Flat file data
from DSO to Cube.Its is Data Mart.Loading data from a
infoprovider used as data target to another data target.The
concept we used is DATA MART.

Answer / yash

data mart are specific ,repository of data, designed to
answer specific users.( examaple :sales)

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

---

Explain the difference between mapping parameter and mapping variable?

1 Answers  

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

1 Answers   Cap Gemini,

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1 Answers   Informatica,

---