1.)I am creating custom profile on the relational source because it is failing to create report due database fatal error (some table name pm_dp_m doesn't exists in the repository) but when i check
What is the most complex logic you have used in your ETL design?
Latest Answer: let a given data is like10 a,b,cseparate it as10 ...
i am retrieving the multi structures from source i want to define single target table structure for this which transformation i need to follow
Latest Answer: joiner ...
In source qualifier transformation we can writer customer query. That means we can do aggregator calculations also. So what is the need of Aggregator Transformation?
Latest Answer: Sourcequalifier transformation filters rows when it reads the souce data from the PowerCenter Server if you give any filter condition, but Aggregator transformation is used for multiple filter conditions and even it will have default condition so ...
What is the difference between "external procedure transformation" and "custom transformation"?
How to connect two sources with connecting field without using joiner and lookup?
Latest Answer: In that situation it is possible by only source qualifier ...
How to move the mappings to the production server?
Latest Answer: HiFrist export the mapping, it will create a xml file and connect to production repository there import that xml file.Sekhar7791 ...
Where do we apply business rules from souce to staging or staging to warehouse?
Latest Answer: Actually we don't apply business rule . we only treat the data according to the business rule and in this work we get help by business analyst. in staging area we generally do cleansing and scurbing then we load dimension and in last ...
What is IQD file?
Latest Answer: In Cognos u will have impromptu (reporting tool) in this all the report will be stored as report.IMR which is one dimensional (single view ) report .but when we want to build cubes IMR file type will not be accepted ...
How to find out duplicate records using aggregator. Pls explain with example. What is the need for placing joiner after aggregator. I just tried like the following:Count the records and group by all the
Latest Answer: When we are removing duplicate rows using aggregator we have to check all the ports by group by ports. Without using summation, we can eliminate duplicates by using aggregator. ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>

Go Top