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?
1497Post New Informatica Questions
How many ways are there to do 'remove duplicate records in informatica'?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
wat are deployement groups in informatica, how it will be used for developers
What is complex mapping?
What are the transformations that are not supported in mapplet?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to update or delete the rows in a target, which do not have key fields?
How to join three sources using joiner? Explain though mapping flow.
Define enterprise data warehousing?
whats the logic to load the lower level of granularity of data to fact table.
What do you mean incremental aggregation?
What is session task and command task?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks