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.

daily how much amount of data send to production?

4 Answers   HSBC,

---

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

---

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

How do you use reject loader.

0 Answers  

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

Informatica settings are available in which file?

0 Answers   Informatica,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

---

Explain about Recovering sessions?

1 Answers  

---