By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?14 35010
In real time scenario where can we use mapping parameters and variables?4 26659
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 12069
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 4945
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.10 25080
How to generate a single mapping for both the historical and incremental load.2 5161
What are the uses of a Parameter file?3 8951
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 9728
when we dont use aggregator in mapping ?2 3917
How many joins in Informatica5 18312
How to identify this row for insert and this row for update in dynamic lookup cache3 5962
What is router transformation4 3314
How to eliminate duplicates in FF and oracle both3 3880
If I am having 6 flat files in data. How can you load the data at a time2 4499
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 5301
what type of questions arrive in interview over c programming?
What is meant by verification point and what is the use of it?
Why did you choose BSC with Microbiology after your diploma in pharmacy and than MBA ? You also could do B.pharmacy and MBA?
What was your reason for leaving?
How to add coverage level to service contracts?
How to get Cursor position using API?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
sir am giving jspl exam on 19th oct . i belong to eee, so plz send previous question papers ..........to dis id firstname.lastname@example.org
What is ngl level and how it is transfer to column or beam??
what is c++
Send me some real time tickets in sap sd with there solutions by link
what is the objective of business taxation in private company?
Why is it that SMS/MO recieves a sent and delivered acknowledgement but MT is not recieving the message?
WHTA IS LIMT OF LEAKGE CURRENT OF 11 KV 1 CORE 1000SQ.MM. XLPE CABLE.LOAD ON CABLE IS AROUND 600AMP .LENGTH 500 MTRS.
Sir. I m a physics graduate ...how can i help in bank with my physics subject...kindly reply ...my id. Pshkumar.email@example.com...please