how to join the two flatfiles using the joiner t/r if there
is no matching port?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update or delete the rows in a target, which do not have key fields?

761


Where are the source flat files kept before running the session?

721


In informatics server which files are created during the session rums?

731


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1797


What is difference between a gateway node and worker node?

734






Define enterprise data warehousing?

742


What do think which one is the better joiner or look up?

849


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1764


What does command task mean?

696


What do you mean incremental aggregation?

716


How to generate or load values in to the target table based on a column value using informatica etl tool.

707


Which is the t/r that builts only single cache memory?

821


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1423


How you know when to use a static cache and dynamic cache in lookup transformation?

1425


What are active transformations.

1291