Answer Posted / chinmay
Junk dimesnion is aimension table consisting attributes
that do no belong to any fact table or any form of existing
dimesnion .
Usually it is used to hold indicator yes/no , true/false.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How might you approve all mappings in the archive all the while?
How do you convert single row from source into three rows into target?
wf dont have integration severances how you can run?
According to his methodology what all you need before you build a datawarehouse
What is workflow? What are the components of the workflow manager?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are roles and groups and benefits of using them?
What are the designer tools for creating transformations?
How to create a non-reusable instance of reusable transformations?
what is Active lock explain
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are different types of transformations available in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what is size of u r database?