Answer Posted / raj

IN THREE WAYS WE CAN GET THE LATEST RECORD IN SCD ...

1)IN "SCD TYPE 2 TIME STAMP" FOR LATEST RECORD THE "END
DATE" FIELD WILL BE BLANK. THAT MEANS IT IS THE NEW ROW .

2)IN "SCD TYPE 2 FLAG " THE FLAG NUMBER OF THE NEW ROW WILL
BE ONE .

3) IN " SCD TYPE 2 VERSION " THE LATEST RECORD IS HAVING
THE MAXIMUM VERSION NUMBER .

What is informatica? Why do we need it?

1082

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2256

---

What is sq transformation?

1139

---

what is INFORMATICA TESTING process

2276

---

Explain how many types of dimensions are available in informatica?

1073

---

How can you validate all mappings in the repository simultaneously?

1351

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2040

---

Explain what transformation and how many are there in informatica?

924

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2189

---

What do you mean by filter transformation?

938

---

Please let me know how to make Data masking in informatica..

1699

---

What is expression transformation?

1086

---

what is diff b/t sorter t/r and agg have the option sorter property...

2160

---

Did u used latest transformations of 8.6.0? for what?

1870

---

How might you approve all mappings in the archive all the while?

1005

---