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
- 9476 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 INFORMATICA TESTING process
Do you find any difficulty while working with flat files as source and target?
Write the unconnected lookup syntax?
Explain what is informatica metadata and where is it stored?
What is informatica worklet?
How many numbers of sessions can one group in batches?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Explain what transformation and how many are there in informatica?
Explain the scenario which compels informatica server to reject files?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to elaborate powercenter integration service?
COM components can be used in Informatica
What is native users?
