Answer / abhishek kumar

STEP:
1)FIRST JOIN FILE B AND FILE D HERE FILE D AS A MASTER AND
FILE B AS DETAIL.
2)THEN JOIN FILE A AS MASTER WITH OUTPUT OF STEP 1.
3)THEN JOIN FILE C AS MASTER WITH OUTPUT OF STEP 2
THIS THE RESULT.

IN JOINER
IF WE GO JOIN FOR TWO TABLE WE CHOOSE THAT TABLE AS A
MASTER WHICH CONTAIN MINIMUM RECORD OR LESS REPETION.
ACTUALLY COMPARE TO DETAIL , MASTER CACHE SIZE IS LESS.AND
OUTPUT RESULT WILL BE GO TO DETAIL

THANKS
ABHISHEK GUDDU

Name the different lookup cache(s)?

0 Answers  

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

what are types of dimentions?

3 Answers  

---

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

---

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

What is predefined event?

1 Answers  

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

What will be the approach?

0 Answers  

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---