Answer Posted / 8/5/08
Requirement and Analysis
Design
Coding
Verification
Maintainance
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Where is metadata stored?
In development project what is the process to follow for an etl developer from day1
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.
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
What are the types of schemas we have in data warehouse.
What does cheating measurement mean?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are junk dimensions?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How many transformations can be used in mapplets.
What are the different types of transformation available in informatica.
What is a difference between complete, stop and abort?
Explain about Informatica server process that how it works relates to mapping variables?
Explain joiner transformation in informatica
Please let me know how to make Data masking in informatica..