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

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

What is an active transformation?

0 Answers   Informatica,

---

how to duplicates from expression transformation without using sorter before that

1 Answers  

---

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

---

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---

What is native users?

0 Answers  

---

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

---

define galaxy repository in informatica

0 Answers  

---

Reusable transformation and shortcut differences

0 Answers  

---

How to import oracle sequence into Informatica?

3 Answers   Satyam,

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---