Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

what is semi-additive fact?where did u used?

2 Answers  

---

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

---

What are the types of caches in lookup?

0 Answers  

---

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

---