Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / parthasarathi swain
A Dimension table is a table that contains detailed and
consistent data ie those data that are not frequently
changing in the other words we can say those as master data.
We use the primary key of the dimensional table as the
foreign key in the fact table. For one fact table we can
have more than one dimensional table.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What differs when we choose the sorted input for aggregator transformation?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
can you please explain me pre session and post session options?
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?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain direct and indirect flat file loading (source file type) - informatica
wat are deployement groups in informatica, how it will be used for developers
What you know about transaction control transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is aggregator transformation in informatica?
Which development components of informatica have the highest usage?
What is status code in informatica?
How can we use mapping variables in informatica? Where do we use them?
What is a connected transformation?
