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
- 18523 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 |
What is junk dimention?
Performance wise which is better joiner or look up ? Give me with example?
When to use normalization transformation other than cobol source?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
How will you convert rows into columns or columns into rows
what is the function of 'F10' informatica ?
What are variable ports and list two situations when they can be used?
how i will stop my workflow after 10 errors
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
How can we use batches?
Teradata 
