By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?14 39340
In real time scenario where can we use mapping parameters and variables?4 28507
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 13988
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 5769
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.10 28914
How to generate a single mapping for both the historical and incremental load.2 6004
What are the uses of a Parameter file?3 10603
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 11894
when we dont use aggregator in mapping ?2 4610
How many joins in Informatica5 20441
How to identify this row for insert and this row for update in dynamic lookup cache3 6982
What is router transformation4 4200
How to eliminate duplicates in FF and oracle both3 4624
If I am having 6 flat files in data. How can you load the data at a time2 5329
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 6418
what is directory assistance?
Why is eriochrome black t indicator cannot be used in this experiment?
In which year national housing bank (nhb) started its operation?
what is rsa algorithm?
Will width property uses full width of browser?
What are the four c’s of digital marketing?
Do we have to use http get/post for the ajax calls?
Hi Im Arun D. I m short listed for Karnatka bank interview. Can anybody share ur experiences regarding Bank interview of karnatka bank which was held on dec for Clerical post. Please help me I f u can. thanx in advance
Which is faster mysql or mongodb?
How do I edit html in joomla?
what are the balancing segments in AR?
Explain how you would be an asset to EOG?
What is the sequence of execution of Mapper, Combiner, and Partitioner in MapReduce?
What is cms wordpress?
What are different types of spring bean autowiring?