Answer / abhinaw prakash

Depends for what purpose are you using your staging table.
In some cases we ll use a Landing table(Truncate and load) just before Staging(SCD1). In cases where we wont use such landing tables Staging will be Truncate and Load.

Answer / nawin

Stage is mostly Truncate and load, also it is a full load concept.

Answer / p

stage is a incremental load.we truncate existing data and load incremental data.

how do u move the code from development to production?

6 Answers  

---

what is unique constraint error ?

2 Answers   TCS,

---

Describe expression transformation?

0 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

what is the difference between stop and abort

2 Answers  

---

---

explain about session partitions ?

1 Answers  

---

what are the perameter and variable?

3 Answers   IBM,

---

Explain the different dimensions.

0 Answers  

---

What is a design?

1 Answers  

---

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---