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

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

---

How does the session recovery work.

1 Answers  

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

---