Interested to Buy Any Domain ? << Click Here >> for more details...
how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 27554 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / nisith
Dear,
Whenever you required changes in your target as a lookup
than go for dynamic.Static means its a readonly why do u
want your server to busy..so stick on static only
comparison is there thats it....
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the use of transformation?
Where are the source flat files kept before running the session?
Explain the use of aggregator cache file?
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
Explain sql transformation in script mode examples in informatica
What is expression transformation?
What are the new features of informatica 9.x developer?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Which is the t/r that builts only single cache memory?
Parameter and variable differences
Can we change Dynamic to Static or Persistent cache? If so what happens?
Describe data concatenation?
According to his methodology what all you need before you build a datawarehouse
what is song in infrmatica...?
