Answer / swetha

The informatica server follows instructions coded into
update strategy transformations with in the session maping
determine how to flag records for insert,update, delete or
reject

If you do not choose data driven option setting, the
informatica server ignores all update strategy
transformations in the mapping.

Answer / shashiall

select Data Driven in Update Strategy Transformations.
if not ...then the informatica sever wil not consider
it and will ignore this.
Data driven is not Used when using the BULK load.
(may b it is correct ..plz try this)

What is workflow monitor?

0 Answers  

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

why we use datawarehouse

0 Answers   HCL,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

---

 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,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

What is souce qualifier transformation it is active or passive

2 Answers   HCL,

---

can u give example for factless fact table

2 Answers   TCS,

---

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---