By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
14 47933Hi 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 17882I 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 8234Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
10 34289what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 15099CANNOT 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 9014Post New CSC Informatica Interview Questions
Can both account based and costing based profitability analysis be configured at the same time? : co-pa
Explain what is the difference between sy-tabix and sy-index? Where it is used?
where can i learn VB scripint ?
How can we import the data into a database using sql * loader?
what is the panel name of ispf primary option menu?
What are the classifications of the cics program?
1. What is product proposal? 2. How do we do the campaign execution? 3. Difference between campaign automation and campaign execution
Should I learn python or scala?
What are bots in automation anywhere?
please tell me wat types of technical questions will be asked in Alcatel lucent. and suggest me which site to view
What are advantages of REST web services?
You have a video transcoding application. The videos are processed consistent with a queue. If the process of a video interrupts in one instance, it resumes in another instance. Presently there’s a large backlog of videos that must process, for this, you wish to feature a lot of instances. However, you would like these instances solely until your backlog reduce. That of those would be an economical way to do it?
What do you mean by aspect?
how to handle exceptions?
what is the transfection reagent for HT-29 and HCT-116 cells ?