How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
- 4 Answers
- 17100 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jvdwhinfo
Hi Guys,
First of all create a new flat file and paste the location
of all the flat files in that newly created flat file.
Now import the source definition using "Import from file"
and define the mapping.
And assign the session properties as indirect file type of
loading and give the location of the newly created file.
This should do and please let me know if you want me to
discuss further.
Thanks,
James
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is SDLC way of code development?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the types of lookup transformation?
Describe data concatenation?
Explain how many types of dimensions are available in informatica?
What does refresh system mean, and what are its distinctive choice?
Describe an informatica powercenter?
What is the difference between Active and Passive transformation?
How to convert multiple rows to single row (multiple columns) in informatica
Informatica settings are available in which file?
What is repository manager?
What is the status code in stored procedure transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the difference between a repository server and a powerhouse?
Mention some types of transformation?
