-
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???...
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 transThanksBabu Shiv
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 transforma...
-
Checksum and Pipeline
What do you mean by Checksum and Pipeline in Informatica? Where do you use it ?
Mamta11
- Jul 26th, 2008
Pipeline in information means a series of transformation starting from one set of sources to a target set of targets.
subashreddy77
- Apr 27th, 2008
Hipipeline is the flow of data from source to target using some transformations(if required)tell me if u got what is check some and where it is usedif i was wrong please tell me where i am wrongbye nad take care
-
Dimension Tables and Fact Table
How many Dimension tables can connect to a Fact table?
jryan999
- Sep 1st, 2008
The number of Dimensions depends primarily on the requirement. I have built systems with a few FOUR Dimensions on a Fact and as many as TWENTY. There is no physical limit imposed by either...
subashreddy77
- Apr 27th, 2008
Hiwe can connect as we like but it will be generally based on requirements
