Interested to Buy Any Domain ? << Click Here >> for more details...
how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
- 2 Answers
- 7259 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gm
You load dimension table before loading fact table. But
using Dynamic Lookup, you can load both simultaneously.
======
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / abc
I think use the constraint load order and target load order
plan
| Is This Answer Correct ? | 0 Yes | 1 No |
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
How to import oracle sequence into Informatica?
In warehouses how many schemas are there?
What are Target Options on the Servers?
Can informatica load heterogeneous targets from heterogeneous sources?
What is meant by query override?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
comonly how meny mappings r there in Banking projects?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
how can we perform incremental aggregation?explain with example?
list out all the transformations which use cache?
Teradata 
