conncet the flat file to sorter transformation and select 
distinct option.

design is used for to identify what type of object is this.

polling is the updated information about session in monitor
window.the monitor window displays the status o session when
you poll informatica server

Unit testing in Informatica performed using ...

1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.

2)column to column mapping to make sure the result passing
to columns are correct.

3)data type mismatch or matched.

Target Types are File, Relational and ERP. Latest Answer : 
PowerCenter can load data into the following targets: 
Relational. Oracle, Sybase, Sybase IQ, Informix, IBM DB2, 
Microsoft SQL Server, and Teradata. File. Fixed and 
delimited flat file and XML. Application. You can purchase 
additional PowerCenter Connect ...

Requirement and Analysis
Design
Coding
Verification 
Maintainance

Feasibility Study
Requirement Analysis
Design
Construction(Coding)
Testing(Unit testing,Integration Testing etc)
Implementaion

by using the load manager

use mapping designer create source db file as well as tgt
flat file with required column information .

While creating session provide the tgt file directory to get
the information.

It should be a direct 1-1 mapping, source having relational
table and Target a Flat file

Persistent cache: U can save the lookup cache files and
reuse them the next time the informatica server processes a
lookup transformation configured to use the cache.

Recache from database: If the persistent cache is not
synchronized with he lookup table,U can configure the lookup
transformation to rebuild the lookup cache.

Static cache: U can configure a static or readonly cache for
only lookup table.By default informatica server creates a
static cache.It caches the lookup table and lookup values in
the cache for each row that comes into the
transformation.when the lookup condition is true,the
informatica server does not update the cache while it
prosesses the lookup transformation.

Dynamic cache: If u want to cache the target table and
insert new rows into cache and the target,u can create a
look up transformation to use dynamic cache.The informatica
server dynamically inerts data to the target table.

shared cache: U can share the lookup cache between multiple
transactions.U can share unnamed cache between
transformations inthe same maping.

SCD 2 is coplex mapping

A complex mapping  generally will have the following 
charectaristics
1.difficult requirement
2.More no.of transformation
3.having difficult business logics 
4.may require combinatio of two or more methods combination

data modelling means breaking entity relation between 
tables and  bulid up of d/w using schemas by dimensional 
modelling

just by place the mappings in the shared folder

import mapping into XML and then export it then using rep 
manager

10jan1962 it will store and the format is date9.

12/31/1961
data a;x=730;;proc print data=a; format x mmddyy10.;run;

In SAS Dates stored in numeric format, it starts from 1st 
Jan 1960, so 730 means Jan 1962.

it may be dec 31 1961 or jan 1 of 1962

it may be 29 dec 1961