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
- 18129 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
by using a concept called filemerging
we will give the path of all files in a sinle file
and in session properties select file type is indirect
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
What happens if we dont select data driven option?
How can we eliminate duplicate rows from flatfile,explain?
In warehouses how many schemas are there?
What are the designer tools for creating transformations?
What if the source is a flat-file?
what is the command to get the list of files in a directory in unix?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
What are the different lookup cache(s)?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
how will you remove the duplicate records from flat file without using sorter?
Teradata 
