Answer Posted / sujana

create a flatfile for 1st and 2nd records...keep lukup on dis table..if condition doesnt match it inserts the record (use not equal operator in condition)..

crct me if im wrong

Define mapplet?

997

---

How to update a particular record in target with out running whole workflow?

1568

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1481

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2011

---

Is stop and abort are same in informatica?

988

---

What do you mean by enterprise data warehousing?

1038

---

Enlist few areas or real-time situations where informatica is required.

1059

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1954

---

tell me the rules and responsblites in our project(my project is development)

1918

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2039

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2346

---

What are the main issues while working with flat files as source and as targets ?

1140

---

How will the document be delivered to me?

1062

---

How are indexes created after completing the load process?

1622

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1790

---