Answer / raju2

data modelling means breaking entity relation between
tables and bulid up of d/w using schemas by dimensional
modelling

Answer / jeevan kumar medapati

this is the process of designing the data base.in real time
data base architech (or) data modeler design the data base
by using GUI base data base designing tool ERVIN.
3 types of data models can be defined (1)star data model
(2)snoflake data model
(3)galaxy data model

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

Informatica settings are available in which file?

0 Answers   Informatica,

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

---

what is surrogate id ?

3 Answers   IBM,

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

what is update strategy transformation ?

7 Answers   TCS,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

---