Answer / sayan

yes we can use bulk load if we are using static lookup.
condition: 1. we are not using a dynamic lookup on the target table. 2. There is no duplicate in the record in the data.

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---

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,

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

---

How many cubes create from a single model?

1 Answers  

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

How to import oracle sequence into Informatica?

3 Answers   Satyam,

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,

---