Answer / sanjay

By using the scd2..we can keep the track of the old and new
records.
There are 3 ways:
1.Version Num
2.Date
3.Flag

Answer / srikanthlavu

old values you might store in target right?then use that
old values for comparision of new values by using lookup
tranformaton....give key port lkp t/n from sq and give
condition like oldvalue=newvalue
if condition true means those are old vakues

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

what is junk dimension

4 Answers   Cap Gemini,

---

What is the use of transformation?

0 Answers  

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

---

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

---

How do you change a non-reusable transformation to reusable transformation?

0 Answers  

---

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

how to join two flat files in informatica?

3 Answers   Wipro,

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

---

can u give example for factless fact table

2 Answers   TCS,

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

---