HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?

Answer Posted / avru.bal

we can join the 2 flat files by using filerepsitory..save
both files in one directory gve the path name c:\.txt and
provide default type=oracle then apply,
in session properties provide
source file directory:c:/txt
source file type:indirect
provide target connection..so that we can join the both
files without using joiner n lookup

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9164


what is index?how it can work in informatica

1579


Have you worked with/created Parameter file

1224


How to update a particular record in target with out running whole workflow?

1154


How to load data in informatica ?

568






what are the different types of transformation available in informatica. And what are the mostly used ones among them?

535


How to generate sequence numbers using expression transformation?

636


tell me the rules and responsblites in our project(my project is development)

1494


What is transformation?

656


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

707


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3320


How can we remove the duplicates from flat file source?

574


What is informatica?

677


Can you generate sequence numbers without using the sequence generator transformation?

597


How to join three sources using joiner?

570