how to import multiple flat files in to single target where
there is no common column in the flat files
Answer Posted / kotesh
using filelist concept, we can acheive this one.
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Which transformation is needed while using the Cobol sources as source definitions?
What is the command used to run a batch?
How can repository reports be accessed without sql or other transformations?
What are the different transaction levels available in transaction control transformation?
Repository user profiles
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
State the differences between sql override and lookup override?
how to load dimension table and fact table. plz tell me the steps.
What are the data movement modes in informatica?
What are the tasks that source qualifier perform?
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 do think which one is the better joiner or look up?
According to his methodology what all you need before you build a datawarehouse
what is the size of your data warehousing?