,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
- 7072 Views
- Emphasis, I also Faced
- E-Mail Answers
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 |
I have source like this 1:2;3. so i want to load the target as 123
Explain about Informatica server process that how it works relates to mapping variables?
how may sources can be used in a mapping at a time?(limit)
Explain the aggregator transformation?
What is data caches/ index caches?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
How we can confirm all mappings in the repository simultaneously?
Explain the different kinds of facts.
How the informatica server sorts the string values in Rank transformation?
in oracle write query yourname+1 from dual
In informatica workflow manager, how many repositories can be created?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Teradata 
