,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 |
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is diff joiner and lookup
How can i send first half of the records to one target and Remaining to other target?
Whats there in global repository
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
What is the difference between SOURCE and TARGET BASED COMMITS?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
Explain what is informatica metadata and where is it stored?
What is the difference between Normal load and Bulk load?
How to fix the etl bugs..Tell me the process?
Can yoU use the maping parameters or variables created in one maping into another maping?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?