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
- 13417 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 |
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
how can u tune u r informatica mapppings
What is meant by LDAP users?
What are the measure objects?
How would you copy the content of one repository to another repository?
What is a surrogate key?
what is mystery dimension?
What are the options in the target session of update strategy transsformatioin?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
How to differentiate between the active and passive transformations?
How can you differentiate between powercenter and power map?
what is the predefined port in dynamic lookup
Teradata 
