Answer / dk2bbr

desc tablename;

Answer / ashish

Use Desc Table_name

I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  

---

Can u access a repository created in previous version of Informatica?

0 Answers  

---

Explain do we need an etl tool?

0 Answers  

---

What is factless fact schema?

3 Answers  

---

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

0 Answers  

---

what are the production issues in datastage?

0 Answers  

---

Explain me ETL project architecture in Detail?

0 Answers   Infosys,

---

how do u identify the changed records in operational data?

0 Answers   QualTech,

---

how do use session mapping parameters ?(in which transformation)

0 Answers  

---

when will use SQL override in a lookup transformation?

0 Answers  

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  

---

Difference between flat files and relational sources?

2 Answers  

---