Answer / moorthy g

Whenever the source table have non key columns but I want to
update in the target table then you have to go for target
update override.

Target Properties - Update Override - give some update
condition.
Correct me If I'm wrong
Thanks
Moorthy

Answer / ankur saini er.ankur861@gmail.

Hi

Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)

What aer the out put files that the informatica server creates during the session running?

4 Answers  

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

What is an Integration service in Informatica?

0 Answers  

---

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

What are the different threads in DTM process?

2 Answers  

---

What is main use of mapplet?

0 Answers  

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

What are the different threads in DTM process?

1 Answers  

---