how to join the two flatfiles using the joiner t/r if there
is no matching port?
Answers were Sorted based on User's Feedback
Answer / sudhar
Connect the source Qualifier of two different flat files to
two different Exp Trans. Create a dummy output port in both
the exp trans. then using that port connect the joiner
Tansformation
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / jana
yes you can join two flatfiles using the joiner t/r even if
you don't have any matching port for that you need to take
one dummy column in source files and based on the dummy
column you can join them
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / alisha
Hi Sudhar
What condition we need to give in Joiner transformation to
join tht dummy column.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vin
create dummy1 port in flat file1
create dummy2 port in flat file2
assign the value '1' to both dummy1 and dummy2.
In the lookup condition use dummy1=dummy2. This is going to be always true so all the records are took into consideration.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vaas
Hi Jana,
How can we take a dummy column i.e what r the values would
be in that port? We need to take dummy columns on both files?
could u explain clearly. mi id is vaas31@yahoo.in
Is This Answer Correct ? | 2 Yes | 1 No |
To achieve the session partition what r the necessary tasks u have to do?
What is source qualifier transformation in informatica?
What is Data Caches size?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
what is curr val use for in sequence generator?
How do you take back up of repository?
Can i create a lookup table without cache.
Can we create two repositories on same database instance in oracle?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is materialized view?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
what is the difference between mapplet & stored procedure?