Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mln
thsi is the data base used to captur daily business
activites and this is normalized databse.
| Is This Answer Correct ? | 22 Yes | 9 No |
Post New Answer View All Answers
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.
Parameter and variable differences
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Tell me about Propagate functions in informatica
Do you find any difficulty while working with flat files as source and target?
How to load last n records of file into target table - informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is a joiner transformation?
how to load rows into fact table in data warehouse
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the popular informatica products?
How many ways are there to do 'remove duplicate records in informatica'?
what is degenerated dimension?
Explain how many types of dimensions are available 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
