Answer Posted / bebo
a confirmed dimension is a dimension which is used in more
then one datamart...exp time dim or customer dim
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are some examples of informatica etl programs?
Sequence generator, when you move from develoment to production how will you reset
Briefly define a session task?
What do you understand by term role-playing dimension?
Plz can any one say me how to get the informatica certification materials and dumps
Under what condition selecting sorted input in aggregator may fail the session?
What is a standalone command task?
What is dimensional table? Explain the different dimensions.
What is event and what are the tasks related to it?
Did u used latest transformations of 8.6.0? for what?
What is fact table? Explain the different kinds of facts.
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
What is rank transform?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?