Answer / kal_leo@hotmail.com

Assign ur extraction process to any session or workflow.
And session or workflow can be executed(commandline) using
PMCMD command and save the command in a batchfile and
automated that batch file using any scheduler.

Thanks

Kal

list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  

---

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  

---

what are the parts of Informatica server ?

1 Answers   GE,

---

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

---

What is grain of fact?

0 Answers  

---

Explain about power designer data modeling software?

0 Answers  

---

Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,

---

what is HISTOGRAM? how to generate statistics?

1 Answers  

---

what is an ETL or ETT? And what are the different types?

0 Answers  

---

if i have a query as flat file how can we load data to target table

0 Answers   Tech Mahindra,

---

Eliminating of duplicate records without using dynamic lookups

1 Answers  

---

what is the main role of FI on business

0 Answers  

---