By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
14 35401Hi 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 12337I 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 5007Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
10 25555what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 9996CANNOT 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 5385Post New CSC Informatica Interview Questions
Why reactors use before incoming of ac vvfd drive?
what is meant by shear center?????
an upper layer message is split into 10 frames each of which has an 80 percent chance of arriving undamaged.if no error control is done by the data link protocol,how many times must the message be sent on the average to get the entire thing through?
For RCD (Residual current device) Icu is defined. How i can find Ics for them?
what is the purpose of checked Menu options
i am electronics & comm engg & appling 4 the AAI jr executive (electronics/ATC) written test. pls forward me the syllabus & old question papers.I will be very much thankful to you akil403@yahoo.com
If I have to write the test cases for any report & there is date box.then may I have to write only select date or have to write all steps required for selecting date
What is chemical composion test
what is data entry? what is report generation ?in accounting how it is used .
How Mapper is instantiated in a running job?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
Describe about Proteus Mirabilis rRNA?
i want a program in c# for 100 or for a number greater than 100.....pls help
Module Pool Programming: Events and Table Control handling.
Suppose My received Interest Income is 24934.59 And for the same time my Bank Charge total is 7785.19. Now the total Bank Charge will be deducted from Interest Income and the amount of (24934.59-7785.19)=17149.40 will be withdrawn to deposit in govt. Account.What will be the Journal Entry for 17149.40. Here, Already Bank Charge 7785.40 is Already Debited and 24934.59 is already credited in Journal.
- C (13)
- OOPS (2)
- C++ General (3)
- VB Script (4)
- SS7 (1)
- Protocols AllOther (1)
- Networking Administration (3)
- ASP.NET (8)
- IIS (1)
- Crystal Reports (3)
- Dot Net Framework (2)
- Dot Net General (1)
- Exchange Server (1)
- Microsoft Related AllOther (1)
- Oracle General (2)
- Database Management (1)
- SQL Server (7)
- MySQL (1)
- DB Administration (7)
- Databases AllOther (1)
- Linux Commands (1)
- Linux Socket Programming (1)
- Linux AllOther (2)
- Unix Commands (1)
- Solaris General (2)
- Solaris AllOther (2)
- Data Structures (1)
- Load Runner (1)
- QTP (4)
- Test Director (1)
- Automation Testing AllOther (1)
- Manual Testing (31)
- QA Concepts (2)
- Test Cases (1)
- COBOL (13)
- JCL (14)
- CICS (3)
- DB2 (2)
- IMS (1)
- IDMS (1)
- Assembler (3)
- VSAM (3)
- IBM MainFrame AllOther (2)
- RPG400 (12)
- DB400 (1)
- IBM AS400 AllOther (2)
- Core Java (9)
- Struts (1)
- J2EE (1)
- Java Related AllOther (1)
- XML XSLT RSS (1)
- Web Related AllOther (2)
- Teradata (1)
- Business Objects (3)
- Cognos (2) Informatica (18)
- Ab Initio (1)
- Data Stage (5)
- Data Warehouse General (1)
- UML (1)
- OOAD (1)
- SAP Basis (5)
- SAP ABAP (48)
- SAP SD (6)
- SAP PM (1)
- SAP FI CO (5)
- SAP HR (2)
- SAP Security (1)
- SAP Netweaver (1)
- PeopleSoft HRMS (1)
- Oracle Apps Technical (1)
- Oracle Apps Financial (1)
- Client Server Architecture (1)
- Client Server General (3)
- WebMethods (2)
- SeeBeyond (3)
- JCAPS (2)
- Civil Engineering (1)
- Electrical Engineering (1)
- Electronics Communications (2)
- Banking Finance (1)
- IT Management (1)
- Audit (1)
- Accounting General (1)
- Accounting AllOther (1)
- Call Centre AllOther (10)
- SSC AllOther (1)
- POs (1)
- Group I (1)
- APPSC AllOther (1)
- General Knowledge_Current Affairs (3)
- Law AllOther (1)
- General Aptitude (15)
- Placement Papers (3)
- L1 Visa (1)
- C Code (8)
- C++ Code (1)
- Oracle Errors (1)
