what is junk dimension

Answer Posted / jani basha

A dimension which can't be used to describe facts is know as junk dimension

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1665


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

630


What are the popular informatica products?

646


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2271


What does refresh system mean, and what are its distinctive choice?

564






Plz can any one say me how to get the informatica certification materials and dumps

1591


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

1403


How will the document be delivered to me?

611


What is the benefit of partitioning a session?

621


What are mapplets?

812


Write the unconnected lookup syntax and how to return more than one column.

590


Explain pushdown optimization and types in informatica

664


What are the types of lookup transformation?

627


What is workflow? What are the components of workflow manager?

704


What all join we can perform in LOOKUP transformation?

559