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.

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

what is the look up transformation?

2 Answers   Informatica,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

Differentiate between a database and data warehouse?

0 Answers  

---

What is lookup change?

0 Answers  

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

what is shared Cache. when we will use shared Cache?

4 Answers  

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---