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.

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

scenario

1 Answers  

---

Enlist the differences between database and data warehouse.

0 Answers  

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

---

What are active and passive transformations?

0 Answers   Informatica,

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---