How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
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 deployemnt groups, Lables, query and dynamic deployment group.
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
What is the scenario which compels informatica server to reject files?
How does the server recognize the source and target databases. Elaborate on this.
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
How can you increase the performance in joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
When you move from devel to prod how will you retain a variable
What are the different options used to configure the sequential batches?
What is pmcmd command?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
Enlist the tasks for which source qualifier transformation is used.