Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sambasivarao.m
First understand the requirements,if any thing not
understandable then sent a mail to client, request for make
sheduled call and as well as in that mail mention what
would be discuss on call.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is fact table? Explain the different kinds of facts.
What is blocking transformation?
Explain how to import oracle sequence into informatica?
what are 3 tech challenges/ common issues you face?
How big was your fact table
State the differences between sql override and lookup override?
What is the command used to run a batch?
Explain the features of connected and unconnected lookup.
What if the source is a flat-file?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the different types of transformation available in informatica.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
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
Repository user profiles
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
