,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?
Answers were Sorted based on User's Feedback
Answer / sree
It is not possible to connect output groups of router with
joiner transformation.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Define enterprise data warehousing?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How you can differentiate between connected lookup and unconnected lookup?
What is the maplet?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the components of the workflow manager?
What is mapplet and a reusable transformation?
what are the Methods For Creating Reusable Transformations?
Explain incremental aggregation in informatica