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?
Answer Posted / lokendra
it will fire in below order workflow,session and data
base perameters from perameter file.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to update a particular record in target with out running whole workflow?
Write the unconnected lookup syntax?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the tasks that can be performed using sq?
How you prepared reports for OLAP?
What is a passive transformation?
list out all the transformations which use cache?
How to do unit testing in informatica?
Explain what transformation and how many are there in informatica?
What is joiner transformation in informatica?
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 is meant by incremental aggregation?
How to improve the performance of a session using sorter transformation?