Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
- 4 Answers
- 18526 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / phani
By using File List we can Merge more than one Flat file.
when we are importing more than one flat file we should Set
the Source Property as INDIRECT,where default property ll
have DIRECT. and we should give the file,which ll have the
adresses of all the Flat files which we are going to merge.
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
what is unit testing?tell me proceedure
What is the function of look up transformation?
Explain the different lookup methods used in informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
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 joiner transformation in informatica?
generate date / time dimension in informatica
What is the difference between informatics 7x and 8x and what is latest version?
What is the difference between router and filter?
How can we use mapping variables in informatica? Where do we use them?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the different components of powercenter?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Please let me know how to make Data masking in informatica..
