Answer / nagendra phani

SUROGATE KEY is used to generate a primary key. and it is
system generated number

Answer / davan

Mainly we r using...the maintain the historical data.and we
can get the data diffrent sources so we can idetified the
every record.

What is the difference between a table and the materialized view?

2 Answers  

---

What is the use of code page?

0 Answers  

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

---

difference between repository database and repository service?

0 Answers  

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

what is difference between dimention table and fact table?

1 Answers  

---

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---

How do you implement scheduling in Informatica?

1 Answers  

---

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

---

Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  

---

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

---