Answer Posted / ananta mishra

1-normal loading will load data first in log file then load
in target.
but bulk loading load the data directly in target.
2- performance will increase where bulk loading will use.

3-u can't recover data when use bulk loading.so for that we
have to start workflow again.

explain about unit testing? in real time?

2181

---

Where do we use mapping variables in informatica?

1046

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1105

---

Explain the tuning lookup transformation - informatica

979

---

What is the benefit of partitioning a session?

1162

---

What is the scenario which compels informatica server to reject files?

1054

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

994

---

What are the new features of informatica 9.x in developer level?

975

---

Explain dynamic target flat file name generation in informatica

1036

---

which one is better performance wise joiner or look up

1073

---

How can we store previous session logs?

1049

---

Explain lookup transformation is active in informatica

1072

---

How to partition the Session?

1088

---

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

7358

---

Sequence generator, when you move from develoment to production how will you reset

2016

---