Answer Posted / priyank
There are some keys which are present in the fact table but
they do not have a corresponding Dimension table related to
them. These are called Degenerated Dimensions.
Eg. Transaction No., Invoice No.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is event and what are the tasks related to it?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Define update strategy?
What is the meaning of decode in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to create a non-reusable instance of reusable transformations?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What you know about transaction control transformation?
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?
Explain sessions. Explain how batches are used to combine executions?
what is SDLC way of code development?
What are different types of transformations available in informatica?
what is informatica metadata?
Explain the different dimensions.
what is the -ve test case in your project.