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.

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

---

What is the Rank index port in Rank transformation?

0 Answers   Informatica,

---

When to use normalization transformation other than cobol source?

2 Answers  

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

---

How can we use batches?

0 Answers  

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

What is session task and command task?

0 Answers  

---