Want to know about Training Centres for Informatica, Cognos
and ETL Softwares in Mumbai, India.
Answer Posted / anand
Study at WWW.geoinsyssoft.com
| Is This Answer Correct ? | 6 Yes | 8 No |
Post New Answer View All Answers
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the difference between informatics 7x and 8x and what is latest version?
What are junk dimensions?
What are the advantages of using informatica as an etl tool over teradata?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Which transformation is needed while using the Cobol sources as source definitions?
How can we use batches?
What is complex mapping?
How to do unit testing in informatica? How to load data in informatica ?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain pushdown optimization $pushdownconfig parameter - informatica
How is union transformation utilized?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
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?