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 a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

tell me the push down optimization

2 Answers   Wipro,

---

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

7 Answers  

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

Mention few power centre client applications with their basic purpose?

0 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

how can u approach u r client

2 Answers   CTS,

---

what is session parameters?

1 Answers   Cap Gemini,

---

What is meant by target load plan?

0 Answers  

---

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

---