Answer / sunil

)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.

NOTE: It is recommended to use staging area

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

---

In informatics server which files are created during the session rums?

0 Answers  

---

What does reusable transformation mean?

0 Answers  

---

In Which scenario did u used Incremental loading?

2 Answers  

---

What are the types of error logs available in Informatica?

1 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

---

What is status code?

2 Answers  

---