Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

What are the different ways to implement parallel processing in informatica?

0 Answers  

---

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---

what is polling?

1 Answers   Informatica,

---

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

---