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.

What is transformation?

0 Answers  

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

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

3 Answers  

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

How will u pas the data with out debugger?

4 Answers  

---

What is the use of target designer?

0 Answers  

---

in which situations do u go for scds ?

3 Answers   TCS,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

---

What is an active transformation?

0 Answers   Informatica,

---