Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / usha
the dimension which is located in a fact table is know
degenerate dimension
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain joiner transformation in informatica
What are the settings that you use to configure the joiner transformation?
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?
Briefly explain the aggregator transformation?
What are the guidelines to be followed while using union transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the meaning of up gradation of repository?
What is the procedure for creating independent data marts from informatica 7.1?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the reusable transformations?
Explain lookup transformation source types in informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is a code page?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
