Which means the first record should come as last record and last record should come as first record and load into the target file?
599Post New Informatica Questions
generate date / time dimension in informatica
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Why filter transformation is an active one?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is flashback table ? Advance thanks
Design time, run time. If you don't create parameter what will happen
Informatica settings are available in which file?
What are the measure objects?
lookup transformation with screenshots
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
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Performance tuning( what you did in performance tuning)
How to load a Dimension ? and how to load a fact table?