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
- 9488 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
How do you remove duplicate records in informatica? And how many ways are there to do it?
How can repository reports be accessed without sql or other transformations?
What are mapplets? How is it different from a Reusable Transformation?
How many dimensions are there in informatica?
How are indexes created after completing the load process?
Make a note of the quantity vaults made in informatica?
tell me the rules and responsblites in our project(my project is development)
what is the hint? how to use it to reduce the query processing in program?
What are the components of the workflow manager?
Define pmcmd command?
What is union transformation in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a repository manager?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Can u generate reports in Informatica?
