By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?14 34649
In real time scenario where can we use mapping parameters and variables?4 26393
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 11842
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 4880
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.10 24723
How to generate a single mapping for both the historical and incremental load.2 5094
What are the uses of a Parameter file?3 8780
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 9469
when we dont use aggregator in mapping ?2 3838
How many joins in Informatica5 18083
How to identify this row for insert and this row for update in dynamic lookup cache3 5885
What is router transformation4 3246
How to eliminate duplicates in FF and oracle both3 3790
If I am having 6 flat files in data. How can you load the data at a time2 4402
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 5227
How to Test IDispatch Descendants?
How to DEBUG Simple Excel to MySQL Convertor?
write a program to set all flags in 8085?
what is separation techniques.
What is the Reducer used for?
How do I know what threshold values to set
What is SNMP ?
Which forms in use in service Tax, Excise duty and Vat for the return.
Does Pig support multi-line commands?
How do I get all users out of VSS in order to perform a backup?
In a flight window we have to enter the name and meal request for every passenger.In that window if we give Total passengers=1 then the Psngr1 name field and psngr1 meal request field will reflects.if we give Total passengers=2 then Psngr1 name field and psngr1 meal request field,Psngr2 name field and psngr2 meal request field and so on. how we can handle this scenerio thru Descriptive programming?
why the rotor current becomes in steady state during high slip region? please verify with equations.
Explain Asynchronous Message Consumption in JMS?
What is a fail-stop signature scheme ?
two way ckt diagram can be drawn by how many ways? give diagram