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
- 7900 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 am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
In Which scenario did u used Incremental loading?
What is an Integration service in Informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
In session log thier should not be a single error how will u do
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
Teradata 
