Answer / subhankar chatterjee

Mapping Variable will store its value in the repository once the Session run successfully.If the session fails the Mapping Variable will not be updated with the new value.

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

what are 3 tech challenges/ common issues you face?

1 Answers   TCS,

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---

Define maping and sessions?

3 Answers  

---

how many types of dimensions are available in informatica?

1 Answers  

---

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

What is informatica worklet?

1 Answers  

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

3 Answers   CTS,

---