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?
1023Post New Informatica Questions
Repository user profiles
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Define mapping and session?
Mention few power centre client applications with their basic purpose?
What is the session task and command task?
wat are deployement groups in informatica, how it will be used for developers
Is it possible to define a single node as a Gateway node as well as worker node?
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.
How do you manage the Parameter files while migrating your data from one environment to another environment?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the different lookup methods used in informatica?
What are 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?
How many dimensions are there in informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
generate date / time dimension in informatica