Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shivaleela
Dimensional Table:-It contains detailed information of one
Particular department
Eg:-Customer dimension it contains all the information
about the customer like name,place,DOB, city n so on along
with one primary key.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How do you convert single row from source into three rows into target?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is meant by pre and post session shell command?
Can we get 1st record through Informatica(without sequence number).
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you load unique records into one target table and duplicate records into a different target table?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
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
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is rank transformation in informatica
Different qualification between a related rotate toward the sky and isolates look upward?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
