By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
14 35819Hi 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 12611I 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 5111Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
10 26050what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 10272CANNOT 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 5476Post New CSC Informatica Interview Questions
as started in the job offer notification, is our basic salary of 1lakh good for you if employed?
How to Open an explorer window to a given folder?
please send latest placement papers of hpcl officers trainee test. i will be very thankful to you.
Question What is datagram, datagram packets and datagram sockets?
Explain Difference between congestion control and QoS(or Quality of service)
principle of dead weight tester ?
Describe a time when you anticipated potential problems and developed preventive measures.
How u can give the overload setting to any motor protection relay for a HT motors with formula and Example?
can we create house for multiple company codes?is it possible to pay cross company code payments? if why please give me answer. thanks for advance
Is there any possibility to copy (into secondary storage devise) the data of company . Please advise
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?
Why do you want to leave your organization or company?
when will the group1&group2 exams will be held
Safety devices in SF6 Circuit Breaker?
can u tell me placement peoceduers and placemnt format of hpcl.
- 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)
