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.

can u any challenge your project?

0 Answers   HP,

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

Difference Between ETL & ELT?

1 Answers   TCS,

What is data movement mode in Informatica and difference between them?

0 Answers  

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,

how to remove staging area

1 Answers