,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?
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
Differences between version 7.x and 8.x.
What is depict expression change?
Explain the scenario which compels informatica server to reject files?
difference between informatica 8.1.1 and 8.6
What is the benefit of session partitioning?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the measure objects?
Is stop and abort are same in informatica?
What is a repository manager?
Parameter and variable differences
What is rank transform?
How can a transformation be made reusable?
How do you convert single row from source into three rows into target?
Explain lookup transformation is active in informatica