Answer / vikram

While populating to target rejected loads will be loaded in
to bad files and we can cross check the data there and the
other way is run the load in verbose mode to check the
exact reason this happens when the flat file data is not in
correct format.

Answer / sarat

The above method tells us how many are missing, after that take the TARGET as Dynamic LKP and update the target for All rows to be loaded

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

Differentiate between Load Manager and DTM?

0 Answers  

---

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

---

How mapping parameter and variable works

1 Answers  

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

How do you load only null records into target? Explain through mapping flow.

0 Answers  

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---