Answer / swetha

The source qualifier transformation does not use sorted ports.

If you change the partition information after the initial
session fails.

Perform recovery is disabled in the informatica server
configuration.

If the sources or targets changes after initial session fails.

If the maping consists of sequence generator or normalizer
transformation.

If a concuurent batche contains multiple failed sessions.

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---

Explain target update override in informatica

0 Answers   Informatica,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

What is the sequence generator transformation in informatica?

0 Answers  

---

What is incremental aggregation?

0 Answers  

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

---

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

---