Answer Posted / pooja

hi,

please get clear picture on the Question...
1. wherther all 3 source are in same schma or in differt
schme ..
if its in differnt schma means use joiner
if its same schma means u cn override the SQ query
2. if no.of columne and datatype are same for all the 3
source means you can use union trans....

How to do the error handling of if ur source is flatfiles?

1948

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1262

---

What are the advantages of using informatica as an etl tool over teradata?

1008

---

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

1837

---

What are mapplets? How is it different from a Reusable Transformation?

1070

---

How is union transformation utilized?

996

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2029

---

What is informatica worklet?

1032

---

What are the different transaction levels available in transaction control transformation?

1170

---

How do you load only null records into target? Explain through mapping flow.

1997

---

what is SDLC way of code development?

2019

---

Explain the different lookup methods used in informatica?

1021

---

difference between informatica 8.1.1 and 8.6

3660

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1996

---

How are the sources and targets definitions imported in informatica designer?

1089

---