Real Time scenario informatoca 9.1

Source table:1

prd_fml_items_d

ITEM_NUMBER	Revisons	Update_dt
R61318C0JRCPQV	437	10122014
sen1234RCPQV	438	11122014
dvop318qwcd	439	12122014
mok234jol89	440	13122014
kol08956rkol	441	14122014
mnokl78654123	442	15122014
dvop318qwcd	443	16122014
kol08956rkol	444	17122014
sen1234RCPQV	445	18122014

Source Table:2

Prd_Entity_ds

ENTITY_PRODCUTS

B/L

Chipmos

Delta (A-B)

Demand -FSCT

FG bank target B

FG+WIP(end of wk)A

Loading -Chipmos

Loading -Nepes

Nepes

My regquirement Target like this:


        

ITEM_NUMBER	ENTITY_PRODCUTS
R61318C0JRCPQV	B/L
R61318C0JRCPQV	Chipmos
R61318C0JRCPQV	Delta (A-B)
R61318C0JRCPQV	Demand -FSCT
R61318C0JRCPQV	FG bank target B
R61318C0JRCPQV	FG+WIP(end of wk)A
R61318C0JRCPQV	Loading -Chipmos
R61318C0JRCPQV	Loading -Nepes
R61318C0JRCPQV	Nepes

 


 Mapping Designer:

Mapping Overview

 STEP 1:

             open to informatica desinger and select two source definitions.from source to Mapping designer drag to source.

STEP2:
            we had two source above mapping.we can define the first pipline exp_t/r create new variale and create to out put variable

    
  STEP:3 Again repeat the above step,in another pipe line like



 STEP:4

          And we can join the two pipelines with defalut ports





Set to Properties Join Transformation:


STEP:5

From joiner t/r connect all ports to Target definition all ports






 Thank You Folks

Please Vistit to my Blog:http://dwbifolkstalk.blogspot.in/

Face Book: dwbi folks