you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  

---

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

---

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

0 Answers  

---

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

0 Answers  

---

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

3 Answers   TCS,

---

Need Informatica Power Center 9.1 free download(for all windows version)

1 Answers   ABC,

---

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  

---

what are the reports developed in sap bw project and what is the requirement for developing it?

0 Answers   Maersk,

---

Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  

---

What are the steps involved in etl process?

0 Answers  

---

how do u set the size of block buffer?

1 Answers  

---