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: What if you want to aggregate the data down the pipeline (after manipulating the source data). This is where you require aggregate transformation. ...
What is the difference between "external procedure transformation" and "custom transformation"?
Latest Answer: The input and output functions occur separately in Custom Transformation. In External transformation both input and output are done by the external procedure function and its parameter consist of all the ports of the transformation. This is because ...
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: With respect to your query. Try getting the session log details regarding the session run. In case if you are not able to get sufficient informations, running the workflow in Verbose data mode. That will give you an exact account where things went wrong.CheersArun ...
in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?
Latest Answer: As per my openion it will insert only because it give preference to session ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>

Go Top