without matching columns in two tables. how can you join

Answer Posted / sivaraj c

Use indirect Load through reference file which holds the file name of both source files.

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the sql query overwrite in source qualifier in informatica

852


explan ur project architecture?

1850


Where do we use mapping variables in informatica?

830


What does update strategy mean, and what are the different option of it?

860


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1797


What does refresh system mean, and what are its distinctive choice?

801


What is domain in terms of informatica?

786


What is blocking transformation?

925


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

3817


What is a joiner transformation and why it is an active one?

787


How do you migrate data from one environment to another?

869


What are the databases that informatica can connect to windows?

819


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1447


Can you generate sequence numbers without using the sequence generator transformation?

854


What is parallel processing in informatica?

1322