Answer Posted / sachin

1.It is also not allow the constraint when we make Target load type as Bulk Mode
2.Also we do not allow to use indexes on database level in Bulk mode But in Normal mode we can allow indexes as well as constraint.

Whats there in global repository

1641

---

How do you handle two sessions in Informatica

1073

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

915

---

Mention some types of transformation?

991

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1842

---

Explain the different lookup methods used in informatica?

972

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1895

---

Explain in detail scd type 2 through mapping.

986

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1792

---

How can we update a record in the target table without using update strategy?

1087

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2277

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1715

---

On which transformations you created partitions in your project?

1250

---

How to join three sources using joiner?

1028

---

How to partition the Session?

1041

---