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
- 8137 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 |
When do you use mapping parameters? (In which transformations)
How can we get multiple output values using an unconnected lookup transformation?
Difference Between ETL & ELT?
Explain the different kinds of facts.
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
In joiner, how to load Master table in Target?
What are the types of maping wizards that r to be provided in Informatica?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
what is the -ve test case in your project.
Explain about the concept of mapping parameters and variables ?
Teradata 
