Answer / bharu_295

using incremental loading

Answer / munireddy

uning incremental/delta/cdc..

for this we have so many logics some of them are..
using mapping level variable
using control table and ....

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

Can you use one mapping to populate two tables in different schemas

2 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

How to implement security measures using repository manager?

0 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

---

How to recover sessions in concurrent batches?

3 Answers  

---

When the informatica server marks that a batch is failed?

1 Answers  

---

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---