What are the out put files that the informatica server
creates during the session running?
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 |
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
How do you load unique records into one target table and duplicate records into a different target table?
What are data-driven sessions?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
difference between stop and abort
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to generate or load values in to the target table based on a column value using informatica etl tool.
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
What do you understand by SOA of Informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?