Answer Posted / vidya acharya

1. SOURCE QUALIFIER TRANSFORMATION represents the rows that informatica powercenter server reads from RELATIONAL or FLAT FILE SOURCE when it runs the session. 

2. When relational or flat file source definition is added to the mapping, informatica server creates the SQ by default. thus, its a default transformation in informatica.

3. Any source(relational/flat file) cannot be read without using SQ as it converts the database specific datatype to informatica native datatype.

4. For relational sources, additional properties can be      configured:
     - join 2 or more table originating from same source
     - source filter.
     - number of sorted ports
     - select distinct rows
     - user defined join
     - specify pre-sql and post-sql query
     - sql override.

Explain the different kinds of facts.

981

---

What is deployment group?

1215

---

Please let me know how to make encryption and decryption with example?

1900

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2171

---

What are the modules in Power Center

1680

---

What is informatica worklet?

1067

---

What are the issues you have faced in your project? How did you overcome those issues?

2365

---

How many input parameters can exist in an unconnected lookup?

1546

---

what is the size of u r source(like file or table)?

2272

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

---

Make a note of the quantity vaults made in informatica?

988

---

how many types of dimensions are available in informatica?

1100

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1085

---

What is mapplet in informatica?

1057

---

What are the performance considerations when working with aggregator transformation?

1152

---