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


Please Help Members By Posting Answers For Below Questions

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

605


Which transformation is needed while using the Cobol sources as source definitions?

729


What is the command used to run a batch?

578


How can repository reports be accessed without sql or other transformations?

730


What are the different transaction levels available in transaction control transformation?

679






Repository user profiles

1377


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?

555


State the differences between sql override and lookup override?

625


how to load dimension table and fact table. plz tell me the steps.

1685


What are the data movement modes in informatica?

703


What are the tasks that source qualifier perform?

633


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

3453


What do think which one is the better joiner or look up?

731


According to his methodology what all you need before you build a datawarehouse

1189


what is the size of your data warehousing?

1673