Interested to Buy Any Domain ? << Click Here >> for more details...
how to join the two flatfiles using the joiner t/r if there
is no matching port?
- 5 Answers
- 13655 Views
- Cegedim, I also Faced
- E-Mail Answers
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 |
What is data caches/ index caches?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
why do u use shortcuts in informatica.?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
What is power center repository?
Under which circumstances, informatica server creates reject files?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
How to compare Source and Target table, without using dynamic lookup?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
How to update or delete the rows in a target, which do not have key fields?
Teradata 
