Answer Posted / jang
Generally for Analaysis, users use reporting tools.. like
Cognos,BO.rtc.... so here they can analysis a product or
item 's across varies regions, departments, vendors.....
Drill up and Drill down is possible with the help of Dimensions.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How many input parameters can exist in an unconnected lookup?
What are some examples of informatica etl programs?
Does an informatica transformation support only aggregate expressions?
What is the difference between Active and Passive transformation?
In development project what is the process to follow for an etl developer from day1
What does refresh system mean, and what are its distinctive choice?
Explain pushdown optimization and types in informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is powercenter on grid?
Why update strategy and union transformations are active? Explain with examples.
Mention few power centre client applications with their basic purpose?
Enlist some properties of sessions.
How to generate or load values in to the target table based on a column value using informatica etl tool.
which one is better performance wise joiner or look up
