Interested to Buy Any Domain ? << Click Here >> for more details...
3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
- 7 Answers
- 10186 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chiranjeevi k
We can use push down optimizationto to handle the huge
volume of data.
Thanks
Chiranjeevi
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the function of look up transformation?
Scheduling properties,whats the default (sequential)
Explain constraint based loading in informatica
tell me the rules and responsblites in our project(my project is development)
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to elaborate tracing level?
how many types of dimensions are available in informatica?
What is joiner change?
How to handle decimal places while importing a flatfile into informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are 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?
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
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the surrogate key?
