Routing Transformation

Hi, I am new to Informatica just trying to do some mappings. I tried to do SCD type 1. after loading source tables I used expression transformation to do some formatting and then I used Router Transformation. But when I tried to post all fields from expression to router they are by default becoming only input variables . I am unable to link these variables to an Update Strategy. What to do now??? Will anyone please help me.
Thank you
Uma

Questions by moola_uma

Showing Answers 1 - 4 of 4 Answers

subashreddy77

  • Apr 27th, 2008
 

hi this is suresh

router is mainly used to filter ,so to get outputs from router u have spicify group with condition then u can take output from that group

double click on router transformation--->groups tab--->new group(u should add)-->spicify the condition



if i was wrong please tell me where i am going wrong

ok bye and takecare

  Was this answer useful?  Yes

Mamta11

  • Jul 26th, 2008
 

You should create a group in router transformation to get the output ports. Create a group and connet the output ports of that group to the next transformation.

  Was this answer useful?  Yes

sakthi.jaganathan

  • Aug 25th, 2008
 

In Router transformation first you want create a group, how can you create a group means, in expression transformation you will set a flag values, you just click the group tab in router transformation and then you give the name as you mentioned in expression transformation and then click ok. Now you can see the group is created in router transformation, and then there will be one more group its name is default group in that the reject records will be present. Now the output group will be also active and you can use it.

  Was this answer useful?  Yes

babushiv

  • Jun 18th, 2009
 

All the Above answers are wright, just create port in group and name it as update if you want to update, by default a port is created, now just map into corresponding router trans from update trans

Thanks

Babu Shiv

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions