how to connect two or more table with single source qualifier?
Answer Posted / rampriya
Create a Oracle source with how much ever column you want
and write the join query in SQL query override. But the
column order and data type should be same as in the SQL query.
Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What are the differences between source qualifier and joiner transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is informatica metadata and where is it stored?
What is the meaning of up gradation of repository?
Explain the difference between mapping parameter and mapping variable?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How can you validate all mappings in the repository simultaneously?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
how many types of dimensions are available in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
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 are the measure objects?
Explain the use of aggregator cache file?
How do you set a varible in incremental aggregation