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
How can you increase the performance in joiner transformation?
What are the measure objects?
Tell me about Propagate functions in informatica
Under which circumstances, informatica server creates reject files?
COM components can be used in Informatica
How many ways are there to do 'remove duplicate records in informatica'?
How can we delete duplicate rows from flat files?
can anyone suggest best free Talend data integration training online
Enterprise data warehouse your projects phase by phase explain?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the prerequisite tasks to achieve the session partition?
What are junk dimensions?
Explain what are the different versions of informatica?
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?
What is the way to execute pl/sql script using informatica mapping?