What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

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

0 Answers  

---

What are the Advantages of de normalized data?

3 Answers  

---

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

generate date / time dimension in informatica

0 Answers   Informatica,

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

design of staging area?

0 Answers  

---

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

---