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
- 9630 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
What is workflow? What are the components of the workflow manager?
What are batches?
While migrating the data from one environment to another environment how would you manage the connections?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is native users?
difference between informatica 8.1.1 and 8.6
What are the informatica performance improvement tips
Explain load alternative records / rows into multiple targets - informatica
Explain the scenario which compels informatica server to reject files?
Differentiate between reusable transformation and mapplet.
What are the reusable transformations?
server hot-ws270 is connect to Repository B. What does it mean?
What does role playing dimension mean?
How do you migrate data from one environment to another?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
