Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / padmavathi
Joiner:
Can join herterogeneous sources.
Can join non-relational sources.
Can join partially transformed data.
Loopup:
Can reuse cache across session run.
Can reuse cache with mapping.
Can modify cache dynamically
Can query relational table or flat file.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain informatica architecture - version 8 / 9
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Whats there in global repository
What are the types of data warehouses?
What is informatica worklet?
How can we use batches?
What is a dimensional model?
Global and Local shortcuts. Advantages.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
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 can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
