Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
- 4 Answers
- 9455 Views
- Wipro, I also Faced
- E-Mail Answers
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
Differentiate between Load Manager and DTM?
What is the reusable transformation?
scenario where i can use only concurrent execution of workflow.
In informatica workflow manager, how many repositories can be created?
What are junk dimensions?
can anyone suggest best free Talend data integration training online
How would you copy the content of one repository to another repository?
What is flashback table ? Advance thanks
Write the program through which the records can be updated?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Parameter and variable differences
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the databases that informatica can connect to windows?
How do we call shell scripts from informatica?
How will the document be delivered to me?
