What are the out put files that the informatica server
creates during the session running?
- 2 Answers
- 6886 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
session log files
workflow log files
Cache files;created and deleted at the end of session.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / chandra sekhar
Integration service log file
session log file
cache file
output file
Reject file
| Is This Answer Correct ? | 1 Yes | 0 No |
what happens if you try to create a shortcut to a non- shared folder?
How to display null values on a target & non-null values on a target?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
what r the values tht r passed between informatics server and stored procedure?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
what is sql override?what is the use of it?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
In a concurrent batch if a session fails, can you start again from that session
What is data movement mode in Informatica and difference between them?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
Teradata 
