explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
Answer Posted / sujith
Above 5,6&7 are the correct for this questions....
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Enlist few areas or real-time situations where informatica is required.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is meant by lookup transformation? Explain the types of lookup transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can we create a node as a gateway node and the same node can be assigned to a grid?
In how many ways we can create ports?
Is it possible to use a client with different version than that of its Informatica server?
What is DR strategy for Informatica project?
Which are the different editions of informatica powercenter that are available?
What are the informatica performance improvement tips
How can we use batches?
Where is metadata stored?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
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 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?