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
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
expain about the tune parameters?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Why do you use Mapping Parameter and mapping variable?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is parallel processing in informatica?
What is aggregator transformation in informatica?
what is the -ve test case in your project.
Could you explain what is enterprise data warehouse?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are different types of transformations available in informatica?
What are junk dimensions?
Explain transaction control transformation in informatica
Define filter transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure