Interested to Buy Any Domain ? << Click Here >> for more details...
i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
- 7 Answers
- 26125 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / raman m
If the 2 flat files have the same structure,then we can go
for filelist concept in informatica.
only one source qualifier is needed and the source should
be either of the flat files.
| Is This Answer Correct ? | 32 Yes | 0 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain incremental aggregation in informatica
Write the prerequisite tasks to achieve the session partition?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to generate or load values in to the target table based on a column value using informatica etl tool.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is index?how it can work in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the difference between router and filter?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
In informatica workflow manager, how many repositories can be created?
what is SDLC way of code development?
How do you change a non-reusable transformation to reusable transformation?
What is workflow? What are the components of the workflow manager?
What are the types of data warehouses?
