Interested to Buy Any Domain ? << Click Here >> for more details...
How to fasten loading of 100 million distinct records in
informatica?
(Initially they are loaded into target without using any
transformation, taking 2 hours)
- 3 Answers
- 11302 Views
- Atriax, I also Faced
- E-Mail Answers
Answer Posted / guest
Partition
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Clarify the aggregator change?
What are the different types of olap? Give an example?
What are the reusable transformations?
What can we do to improve the performance of informatica aggregator transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the conditions needed to improve the performance of informatica aggregator transformation?
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 is a surrogate key?
What are the advantages of informatica?
According to his methodology what all you need before you build a datawarehouse
Explain the different dimensions.
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the difference between source qualifier transformations source filter to filter transformation?
How we can use union transformation?
What are some examples of informatica etl programs?
