Answer / abhinaw prakash

When we want to Update the Target without any Primary key
but with matching columns then we ll go for Target update
override.
The Integration service outputs a Default query,we need to
make the changes according to the column we want to Update.

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

star and snowflake schema?

6 Answers  

---

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

---

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

How to use Normalizer transformation?

2 Answers  

---

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

---

what is session override?

2 Answers   Cap Gemini,

---

What is a unit Testing?

1 Answers  

---

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,

---