How does the session recovery work.1 1349
Why use shortcuts(Instead of making copies).1 2050
where is the reject loader .1 1164
Do you have to change the reject file b4 using reject loader utility.1 2050
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.1407
Mapplets can you use an active transformation in a mapplet,1 1897
What are active transformations? Name them.1 1305
Can a joiner be used in a mapplet.1 2570
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.1 1421
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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How do you convert single row from source into three rows into target?
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?
What is the sequence generator transformation in informatica?
What is the need for an etl tool?
What is the status code in stored procedure transformation?
What is a node in Informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to generate sequence numbers using expression transformation?
Explain why we use partitioning the session in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the use of transformation?
Is it possible to define a single node as a Gateway node as well as worker node?