how to join the two flatfiles using the joiner t/r if there
is no matching port?
Answer Posted / 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 |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what is unit testing?tell me proceedure
wf dont have integration severances how you can run?
scenario where i can use only concurrent execution of workflow.
Write the unconnected lookup syntax?
What the difference is between a database, a data warehouse and a data mart?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
what is song in infrmatica...?
What is the use of transformation?
What is the session task and command task?
What is joiner transformation in informatica?
Performance tuning in UNIX for informatica mappings?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps