What are the basic needs to join two sources in a source
qualifier?
Answer Posted / swetha
Two sources should have primary and Foreign key relation ships.
Two sources should have matching data types.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain sessions?
lookup transformation with screenshots
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 factless facts? And in which scenario will you use such kinds of fact tables.
4 yrs etl devloper roles and responsibilities?any body give solutions
Define filter transformation?
Design a mapping to load a target table with the following values from the above source?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the function of look up transformation?
What is meant by query override?
What are the types of schemas we have in data warehouse.
have u done any performance tuning? how u ll do?
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 we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Differences between connected and unconnected lookup?