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
- 7840 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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do you understand by SOA of Informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Define joiner transformation?
What are the different clients of powercenter?
Explain the difference between mapping parameter and mapping variable?
What is the benefit of session partitioning?
What is deployment group?
Briefly describe lookup transformation?
What is the difference between router and filter?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the tasks that source qualifier perform?
whats the logic to load the lower level of granularity of data to fact table.
have u done any performance tuning? how u ll do?
What is the benefit of partitioning a session?
