By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
14 44054Hi 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 16039I 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 7084Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
10 31574what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 13826CANNOT 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 7784Post New CSC Informatica Interview Questions
What is erythropoiesis?
what r the strategies & methodologies r u following in preperation of test cases based on usecase?
What is the purpose of using break in each case of switch statement?
Hi Friend, I am sap SD consultant & want to learn SAP SD CIN part. there are four Pricing Procedure in SAP SDJINFAC: SALES FROM FACTORYJINEXP: EXPORT SALESJINDEP: DEPOT SALEJINSTK: STOCK TRANSFER But i want to know how to configure Table /Access Sequence /Condition / Pricing procedure/Determination of Pricing proceudre/ Condition record Plz help me with the configuration path of all 4 pricing proceudre of SAP SD CIN
what is us staffing? describe the complete life cycle of the us staffing
hi to all, i need a code.. in flight application 1.i need to login first then i need to insert 3 new orders... 2.i have to log out 3.i have to login again with different user 4.need to insert 2 new orders 5.then need to log out 6.then again login with different user 7.3 new orders create and log out 8.but we hv to do this using data table and actions please help me
please give me different test scenario for uploading whatsapp status from gallery and camera
How do you change the order of columns?
How will you create a bootstrap panel with heading?
where is the first engeenering college of Asia
What is the use of auto format option?
How do I add a form to windows visual studio 2019?
What do you understand from in-memory computing? What is its significance in SAP HANA?
Is an api a web service?
How do I put windows 10 into safe mode?