Interested to Buy Any Domain ? << Click Here >> for more details...
Diff B/W
MAP Parameter,
SESSION Paramater,
DataBase connection session parameters.?
Its possible to Create 3parameters at a time?
If Possible which one will fire FIRST?
- 6 Answers
- 17735 Views
- Accenture, HCL, I also Faced
- E-Mail Answers
Answer Posted / ajalali
A mapping parameter is set at the mapping level for values
that do not change from session to session for example tax
rates.
Session parameter is set at the session level for values
that can change from sesion to session, such as database
connections for DEV, QA and PRD environments.
The database connection session parameters can be created
for all input fields to connection objects. For example,
username, password, etc.
It is possible to have multiple parameters at a time.
The order of execution is wf/s/m.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is a rank transform?
whats the logic to load the lower level of granularity of data to fact table.
What is an expression transformation?
What is workflow manager?
What are the differences between a connected lookup and unconnected lookup?
what is the -ve test case in your project.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the different clients of powercenter?
Explain transaction control transformation in informatica
How do you load only null records into target?
Under what condition selecting sorted input in aggregator may fail the session?
What are active transformations.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
which one is better performance wise joiner or look up
