Interested to Buy Any Domain ? << Click Here >> for more details...
,if we have single SQ in flow and we have router in which it
has two group and we want to join these two groups with
joiner ?is it possible?
- 3 Answers
- 7848 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / adithya amanchi
Router transformation is all about dividing data into group
of records based on one or more conditions. For example,
assuming a building as table with 10 floors considering each
floor as a record. The first three floors are for parking,
next three are for cinema halls and rest are for shopping.
It is nothing but making a vertical table into pieces.
Joiner transformation is nothing but depending upon common
columns(attributes or fields) or primary and foreign key
relationship combining two or more tables horizontally.
Making the table wider. similar to above example, joining
two buildings of different floors making one side of each
building as common.
hope this will help you guys
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is target designer and target load order?
In warehouses how many schemas are there?
What is a predefined event?
How do you set a varible in incremental aggregation
How we can use union transformation?
How to go to the older version for a mapping?
When do you use sql override in a lookup transformation?
Different circumstance which drives informatica server to expel records?
update strategy transformation in informatica
Slowly changing dimensions, types and where will you use them
How can one identify whether mapping is correct or not without connecting session?
How can we improve session performance in aggregator transformation?
Differentiate between joiner and lookup transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is expression transformation?
