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
- 13657 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 |
In a sequential batch can you run the session if previous session fails?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
What are some examples of informatica etl programs?
difference between stop and abort
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
write a query to retrieve the latest records from the table sorted by version(scd)
Diff b/w ShortCut and reusabel Object ?
How to eliminate duplicates from flat file..what is the procedure
What is the difference between unicode & ascii mode data movement in informatica?
write a query to get maximum salary from the employers table without duplicates....kindly help me
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
What is the use of incremental aggregation?
Teradata 
