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
- 25588 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
What is meant by query override?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the modules in Power Center
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is lookup transformation?
What is the need for an etl tool?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain the informatica workflow?
Can informatica load heterogeneous targets from heterogeneous sources?
How might you approve all mappings in the archive all the while?
what is degenerated dimension?
What is flashback table ? Advance thanks
What is the benefit of session partitioning?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What does update strategy mean, and what are the different option of it?
