Calling All Informatica Experts Help Please.

[dharmendra]

ee logic ela rayalo kocham cheppandi.



lookup MSDRG_DIM.MSDRG_KEY

WHERE MSDRG_DIM.MSDRG_NBR=STG_PATIENT_VISIT_DIM.MSDRG_CODE AND

STG_PATIENT_VISIT_DIM.DISCHARGE_DATE=V_FISCAL_CALENDAR_DATE_DIM.FY_DATE_ID AND

MSDRG_DIM.FISCAL_YEAR=V_FISACL_CALENDAR_DATE_DIM.FY_YEAR_NBR

FYI:
O/P PORT :MSDGR_KEY

TABLES:
MSDRG_DIM
STG_PATIENT_VISIT_DIM
V_FISCAL_CALENDAR_DATE_DIM

[Terminator II]

identi.. pl/sql to informatica na..

[_poori]

[dharmendra]

ide informatica requirement. informatica lo ee logic use chesi o\p port ni tesukuravali. msdrg_dim table ni unconnected lkp ga use chesi masdrg_key ni tesukovachu kani remaining conditions ela rayalo ardam kavtam ledhu. aa 3 conditins satisfy chestu aa o/p port ni tesukuravali.

[yankees]

source qaulifier lo rase se ide logic ni..............3 tables ni okate sari source qualifier lo join cheyyi

[FAKEID]

[yankees]

[quote name='FAKEID' timestamp='1350238850' post='1302628510']

[/quote]
wat happened re

[2pac]

what exactly is your question ?
Can you be more detailed in your query?
As per your post, You are trying to lookup stg record in target dimension table.

[dharmendra]

Yes.lookup lo key value return cheyali.stg table source.

[2pac]

Create a lookup TX on [color=#282828][font=helvetica, arial, sans-serif]MSDRG_DIM table[/font][/color].
[color=#282828][font=helvetica, arial, sans-serif]Drag below two ports from [/font][/color][color=#282828][font=helvetica, arial, sans-serif]STG_PATIENT_VISIT_DIM to lookup you just created and rename to I/P correspondingly.[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]STG_PATIENT_VISIT_DIM.[/font][/color][color=#282828][font=helvetica, arial, sans-serif]MSDRG_NBR,[/font][/color][color=#282828][font=helvetica, arial, sans-serif]DISCHARGE_DATE.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]In the lookup SQLoverride write the below query.[/font][/color]


select [color=#282828][font=helvetica, arial, sans-serif]MSDRG_DIM.MSDRG_KEY from [/font][/color][color=#282828][font=helvetica, arial, sans-serif]MSDRG_DIM,[/font][/color][color=#282828][font=helvetica, arial, sans-serif]V_FISACL_CALENDAR_DATE_DIM[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]where MSDRG_DIM.MSDRG_NBR=STG_PATIENT_VISIT_DIM.MSDRG_CODE(I/P port) [/font][/color]
and
[color=#282828][font=helvetica, arial, sans-serif]STG_PATIENT_VISIT_DIM.DISCHARGE_DATE(I/p port) =V_FISCAL_CALENDAR_DATE_DIM.FY_DATE_ID and[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]MSDRG_DIM.FISCAL_YEAR=V_FISACL_CALENDAR_DATE_DIM.FY_YEAR_NBR.[/font][/color]


[font="helvetica, arial, sans-serif"][color="#282828"]Hope this helps...[/color][/font]

[ATRI]

lookup sql override vadu: SELECT [color=#282828][font=helvetica, arial, sans-serif]MSDRG.MSDRG_KEY FROM [/font][/color][color=#282828][font=helvetica, arial, sans-serif]MSDRG_DIM [/font][/color][color=#282828][font=helvetica, arial, sans-serif]MSDRG[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]WHERE MSDRG.MSDRG_NBR=STG_PATIENT_VISIT_DIM.MSDRG_CODE AND[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]STG_PATIENT_VISIT_DIM.DISCHARGE_DATE=V_FISCAL_CALENDAR_DATE_DIM.FY_DATE_ID AND[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]MSDRG.FISCAL_YEAR=V_FISACL_CALENDAR_DATE_DIM.FY_YEAR_NBR[/font][/color]


JOIN CONDITION : [color=#282828][font=helvetica, arial, sans-serif]MSDRG.MSDRG_NBR=STG_PATIENT_VISIT_DIM.MSDRG_CODE[/font][/color]

PORTS IN LOOKUP: MSDRG_KEY, [color=#282828][font=helvetica, arial, sans-serif]MSDRG_NBR, [/font][/color][color=#282828][font=helvetica, arial, sans-serif]MSDRG_CODE[/font][/color]

[font="helvetica, arial, sans-serif"][color="#282828"]only drag MSDRG_KEY to expression [/color][/font][color=#282828][font=helvetica, arial, sans-serif]it should solve the problem[/font][/color]

[dharmendra]

bhayya mari v_fisacl_calender_dim table lo fields kuda lkp lo drag chestunta avatamledhu endukani.