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.

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

What is IQD file?

1 Answers  

---

 Informatica Checkpoints

0 Answers   DELL,

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

---

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---

how can u tune u r informatica mapppings

2 Answers   CTS,

---

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---

how to insert header after each group.

1 Answers   IBM,

---