how to join two flat file if they have diff. structure?how to join one relational and one flat file?

Answer Posted / vijay

you have two flat-files with u.
prepare two source instances with the structure you have as
oracle relational tables. after that change them to
flatfiles in the source instances.
then connect to the target's that u already prepared by
simple-pass mapping. now you have two relational source
tables with u,then join the tables using joiner.
--------------------------------------------------
how to join one relational and one flat file?
same as above convert the flatfile to relational table
through simple-pass mapping. now join two relational tables
using joiner in the same mapping itself.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you increase the performance in joiner transformation?

670


What are the measure objects?

631


Tell me about Propagate functions in informatica

501


Under which circumstances, informatica server creates reject files?

572


COM components can be used in Informatica

1843






How many ways are there to do 'remove duplicate records in informatica'?

559


How can we delete duplicate rows from flat files?

712


can anyone suggest best free Talend data integration training online

1232


Enterprise data warehouse your projects phase by phase explain?

1430


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1891


What are the prerequisite tasks to achieve the session partition?

680


What are junk dimensions?

608


Explain what are the different versions of informatica?

627


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

533


What is the way to execute pl/sql script using informatica mapping?

932