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
- 9259 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
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Is stop and abort are same in informatica?
Which are the different editions of informatica powercenter that are available?
What is the use of target designer?
What is session task and command task?
What is informatica metadata and where is it stored?
How can you differentiate between powercenter and power map?
what is diff b/t sorter t/r and agg have the option sorter property...
Where do we use mapping variables in informatica?
On which transformations you created partitions in your project?
How do you take back up of repository?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the reusable transformations?
What is the difference between informatica 7.0 and 8.0?
What is workflow? What are the components of the workflow manager?
