Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / senthilkumar
Table which contains important business entities called
Dimension Table.
Dimension Tables are also called as Lookup or Reference
Table
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Scheduling properties,whats the default (sequential)
what are factless facts? And in which scenario will you use such kinds of fact tables.
Under which circumstances, informatica server creates reject files?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is rank index in rank transformation?
What is meant by lookup transformation?
What is the sql query overwrite in source qualifier in informatica
How big was your fact table
Slowly changing dimensions, types and where will you use them
What is the scenario which compels informatica server to reject files?
update strategy transformation in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the main issues while working with flat files as source and as targets ?
