By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
14 48343Hi 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 Abhishek
5 18053I 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 8354Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
10 34523what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 15214CANNOT 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? Thanks
4 9140Post New CSC Informatica Interview Questions
What do you know about NIIT Technologies?
How do I see threads in linux?
Explain how to call function in objective-c?
Explain the architecture of angularjs?
What is Collation Sensitivity ? What are the various type ?
When should you use an attribute versus an element?
if company is incorporated on apr25, how to create a fiscal year with period 1 starting from apr25 instead of apr1? (fiscal year is apr-mar)
Why dictionary is used in c#?
How data flows from pp into fi & copa? : co-pa
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Do you know what is rubber fibers?
What is the importance of valence shell and valence electrons?
Is hibernate an implementation of jpa?
Who created word?
What is webapplicationcontext in spring?