Answer / chandrasekar

Whenever an OLTP records update or insert in the source
,then the records are loaded in to target as a new record.

Using SCD type 2 we can acheive the incremental load.

If it wrong means chandranmca2007@gmail.com

Answer / moorthy g

Source --->SQ ----> Expression ---> Target

===> Create Mapping Variable
===> In SQ use sql override
where startdate < $$date

====> In expression use variable port,
setmaxvariable($$date, startdate)
=====================================
You can find variable value in Log fine and session RC you
can find it.

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

---

wf dont have integration severances how you can run?

0 Answers   TCS,

---

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

---

Define the various join types of joiner transformation?

0 Answers  

---

Can we make worklet inside worklet?

1 Answers  

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

What are the scheduling options to run a sesion?

2 Answers  

---

Explain the different lookup methods used in informatica?

0 Answers  

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---