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 |
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
what is the flow?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the function of aggregator transformation?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
In a table, 4 person having same salary. How to get Third person record only?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
design of staging area?
Can a joiner be used in a mapplet.
Explain the use of aggregator cache file?
What are the new features of informatica 9.x in developer level?
where is the reject loader .