Answer / swetha

Join data originating from same source data base.

Filter records when the informatica server reads source data.

Specify an outer join rather than the default inner join

specify sorted records.

Select only distinct values from the source.

Creating custom query to issue a special SELECT statement
for the informatica server to read source data.

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

What is critical mapping?

2 Answers  

---

disable caching in a lookup transformation?

1 Answers  

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

When will you use SQL override in a lookup transformation?

1 Answers  

---

What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---