What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

Insert else update option in which situation we will use

4 Answers   HCL,

---

how many types of dimensions are available in informatica?

0 Answers  

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

---

What is update override?

1 Answers   Accenture,

---