Answer / giri

Tranformation is extract data from one data to another data base in condition,

Answer / prasad

Transformation is a power center object which allows you to
define a business logic for processing the data or
converting the data one format to another format.

two types: active and passive

Answer / praveen.madishetty

A Transformation is a type of metadata object which is
responsible for transforming the data or processing the data

Answer / surya

When transfering the data from Source to Target,we used
multiple steps that steps in informatica is called as
transformations.

Answer / swetha

It is a repostitory object that generates, modifies or
passes data.

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---

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

7 Answers   Infosys, ITC Infotech,

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---