need for registering a repository server
Answer / rkumar.etl
Informatica has concept of license as well as no. of cpu's
registered to the Repository...They programmed the informatica
software in such a way that without registering repository
to machine you can not proceed informatica designer or
workflow designer or other..
In short it is communication channel to read different
source from different box as well as same box.
| Is This Answer Correct ? | 1 Yes | 0 No |
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
How are indexes created after completing the load process?
what is a transforamation?
Whats there in global repository
How we can confirm all mappings in the repository simultaneously?
What is meant by incremental aggregation?
How can you recover the session in sequential batches?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the difference between router and filter?
What is sq transformation?
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
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.