what is the architecture of any Data warehousing project?
Answer Posted / bsgsr
i simply put this way.
source to staging
staging to dwh
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many transformations can be used in mapplets.
What are the reusable transformations?
How do you load unique records into one target table and duplicate records into a different target table?
Differentiate between reusable transformation and mapplet.
How do you load alternate records into different tables through mapping flow?
What is rank transform?
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?
Describe expression transformation?
What is the fact table?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
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 create Target definition for flat files?
What are the advantages of using informatica as an etl tool over teradata?
What is the benefit of session partitioning?
Can we create multiple integration service on single repository?