Answer Posted / maruthi

FLAT FILES SOURCES WILL WITHOUT PRIMARY KEY AND ALL THE
COLUMN DATATYPES WILL BE SIMILER. I.E--CHAR.
RELATIONAL SOURCES WILL BE WITH PRIMARY KEY AND FOREIGN KAY
REALTION SHIP
THIA IS THE MAIN DIFFERENCE,A LOT OF SMALL DIFFERENCES ARE
THEIR.

Explain me ETL project architecture in Detail?

2406

---

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2251

---

what make u disappointmnets in u r career

2261

---

Explain and compare etl & manual development?

968

---

What is fact? What are the types of facts?

1208

---

When do we analyze the tables? How do we do it?

996

---

What are dimensions?

1116

---

Can there be sub steps of etl steps?

1100

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2326

---

tell me few points when u become TL

2605

---

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2164

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1942

---

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1050

---

When do we analyze the tables?

1014

---

can be used COM component in Informatica ?

2104

---