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
- 13772 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 |
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
How we can confirm all mappings in the repository simultaneously?
how can we load starting with 11th record of a table from source to target
what is curr val use for in sequence generator?
Can we have a Mapping without a Source Qualifier?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what is the difference between onsite & client site?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
what happens when a batch fails?
Can we insert ,update ,delete in target tables with one update strategy tran.?
Briefly explain the aggregator transformation?
Explain incremental aggregation in informatica
Teradata 
