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
What is the sql query overwrite in source qualifier in informatica
explan ur project architecture?
Where do we use mapping variables in informatica?
What does update strategy mean, and what are the different option of it?
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?
What does refresh system mean, and what are its distinctive choice?
What is domain in terms of informatica?
What is blocking transformation?
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
What is a joiner transformation and why it is an active one?
How do you migrate data from one environment to another?
What are the databases that informatica can connect to windows?
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?
Can you generate sequence numbers without using the sequence generator transformation?
What is parallel processing in informatica?