Explain the types of transformations?
No Answer is Posted For this Question
Be the First to Post Answer
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
How can we update a record in the target table without using update strategy?
What are the types of presistent cache in look up tr.
How can yoU create or import flat file definition in to the warehouse designer?
How to update or delete the rows in a target, which do not have key fields?
i have two source data there is no pk,fk how to join the two sources
How you load distinct records into one target and duplicate records into another target?
1 lac of flat fles in source how to load target at a time?
Design a mapping to get year of join for each employee.
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?
How many cubes create from a single model?
Explain factlessfact table with scenario