Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
Answer Posted / bidhar
First thing to note is that Both the sources must be
Homogeneous.
Also the Order of the ports in SQ and the order of the
Columns in the select query (if you are using SQL override)
must be same.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the use of an aggregator cache file?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What the difference is between a database, a data warehouse and a data mart?
Explain the different dimensions.
Explain lookup transformation source types in informatica
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
Which transformation is needed while using the Cobol sources as source definitions?
Define pmcmd command?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain the types of lookup transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is mapping debugger?
How do you load alternate records into different tables through mapping flow?