By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
14 46506Hi 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 17071I 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 7767Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
10 33171what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 14610CANNOT 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 8561Post New CSC Informatica Interview Questions
How is employment information is maintained in oracle hrms?
How can I customize the appearance of forms generated by zend_form?
How can I type in cmd?
Enlist the methods to achieve concurrency in ios?
i am a begnner so am learning Error handling :tried using Recovery manager didnt work i want to be able to handle errors , e.g. if while running the test the folwoing does not show up then how can i use the If then else and goto next step in the test, as in many scenarios it does not show up Browser("The Shopping Channel -").Page("The Shopping Channel -_8").Image("easy pay").Click
How to rename an index in oracle?
After creating a customer/vendor, how can we check that under which account group we have configured this customer/vendor?
_____ collection in recordset used to assign a value from textbox to table columns without making abinding in datacontrol.
Is c# and .net same?
How the Internet of Things (IoT) makes a difference to the businesses?
What are the advantages of using laravel?
What are aspect, advice, pointcut, and joinpoint in aop?
What is the difference between wrapper class and primitive?
What is sql*loader and what is it used for? : aql loader
What is use of #include in c?