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
- 7997 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
How can you generate reports in informatica?
have u done any performance tuning? how u ll do?
State the limitations where we cannot use joiner in the mapping pipeline?
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?
can anyone suggest best free Talend data integration training online
What is different between the data warehouse and data mart?
How to Create a folder using pmrep command?
What is pmcmd command?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How will the document be delivered to me?
What is dynamic cache?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Please let me know how to make Data masking in informatica..
What is blocking transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
