By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?14 36110
In real time scenario where can we use mapping parameters and variables?4 27246
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek5 12800
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,3 5187
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.10 26351
How to generate a single mapping for both the historical and incremental load.2 5419
What are the uses of a Parameter file?3 9487
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 10462
when we dont use aggregator in mapping ?2 4118
How many joins in Informatica5 19053
How to identify this row for insert and this row for update in dynamic lookup cache3 6264
What is router transformation4 3521
How to eliminate duplicates in FF and oracle both3 4081
If I am having 6 flat files in data. How can you load the data at a time2 4734
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks4 5547
What can be the challenges during testing a program or a system?
For hot water : please compare to solar heat and heat pump (environment/operation/invest...) Is there any comparison available. Thank you
When CS-CVS should be used?
How Work Manager works in wls 9.2 and above versions?
What changes does a control need to run in an MFC 4.2b container?
define galaxy repository in informatica
what is the magnetic (electric) center)
Difference between traditional and old concept of marketing?
what is the permanent solution applied for restoration of leaning tower of pisa?
Tell me a critical defect in which your Client,PM,PL appreciate on you
What is the general format for a consolidated file extension? It is showing invalid file format? So how to solve the error? How to correct the file format? Help me how to know the general consolidated file format like is it tan no_finan.Yr-quarter-type.Tds is this format correct one? Last time i have found the extension as .Csi is it correct?
what a function diesel generetaor turbo charger & turbo charger is more heated explain reason ?
What is the difference between interfaces and abstract class
Describe how to use megger to measure the earth resistance and insulation resistance
how to calculate entry tax interest rate 2011-2012 assessment pending amt. is Rs.32000