Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?
2 6502Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
1 5019i am having total 10 invoices for a customer but i want to send only 5 invoices to that customer how can i do it?
1 7656HI all, Here my question is i want make payment through APP on behalf of another company code.here my question is i have configured everything in app.when i am making payment it is not working.here we would need cross company code configuration.can anyone please tell me where we have to do or T.code its urgent
5 116731) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
2 7002what is the difference between re-do and mirror log? How it is related with database backup? Please explain the database backup concept in detail. Thanks in advance.:) regards preeti.
2 12197Post New Accenture Interview Questions
Can we implement dealloc in arc? If yes, what is the need to do that?
What are jpa repositories?
What does the c in ctime mean?
Explain the difference between blockchain ledger and a standard one?
What is finally in Java?
what are the effects of price increase? How do you manage price rise and maitain company markert share?
What is meant by vector graphic animation?
What are some common lists that are used when designing a page?
how to create a changeman read only audit and update only audit Specifications for the Read only Audit 1) Read HFFD database unqualified. 2) Read FDRT, FDDM, FDAP segments. If FDAP-APP-STS is ‘2’ read the FDAV segment and get the FDAV segment which has FDAV-APV-OPTION as ‘X’ If FDAP-APP-STS is ‘5’ read the HFAC database. Read the ACRT segment qualified based on the key obtained from the FDAP segment from HFFD database. Conditions for writing into output file: a. App Type should be NEWR b. App Status should be 1, 2 & 5. c. Write 50 records per app status. For e.g. first 50 records for App status 1, 2 & 5 each The output file should contain the following fields from the database FDRT-COMP-CTRY-CODE X(03). FDRT-CUST-ID-NUM X(10) FDDM-DEM-SEQ-NUM X(01) FDAP-APP-SEQ X(02) FDAP-JNT-IND X(01) FDAP-APP-STS X(01) FDAV-APV-OPTION X(01) FDAV-APV-DT X(06) FDAV-APV-AMT X(07) ACRT-ACCT-NUM X(06) ACRT-SEG-BUS-TYPE X(02) ACRT-NM1-LAST X(19) ACRT-NM1-SS X(09) ACRT-NM1-1ST X(12) ACRT-NM1-INIT X(01) ACRT-NM1-SFX X(03) ACRT-NM1-TITLE X(02) PSB – DVAN2BMP In case you get a GE for any of the conditions, write to output file along with the details of the database segment which was not found. We need to complete this whole process by tomorrow. Run the audit in DLI mode. 2) Sort the output file created in step 1 on Cust ID, Dem Seq & App Seq. Specifications for the Update Audit 3) Take the output of step 2 as input for an update audit. Details are as follows: Read each record & check the app status. If app status is less than 2 then update the FDAP-NEW- MONEY-ENT to $25000.00 PSB - AUDBMPJ The job would be a BMP job. The test job would be run in IMSE region. Note - The proc (which will be called by the job) and the job should also be present in the change-man package itself. You’ll have a test job in your PDS along with overrides to execute the program in test regions. The job would be a DLI job. The test job would be run in IMSE region. It’ll have the following steps. 1) Delete-define output and error files. 2) Use a copybook for the output layout.
Define cognos report net?
how do I increase the size of a logical volume?
Someone wants to send a small quantity, say about 500 Kgs., of green coffee beans from Koraput Orissa to Bangalore for Roasting and Packaging of the same there. There will be a loss in weight of about 20% during the processing the green coffee beans into coffee powder, which will then be fit for human consumption. Now, after processing the green coffee beans at Bangalore, the person wants to sell simultaneously a part of the Roasted Coffee Powder to four persons; one of them is in Chandigarh (a registered Dealer in Punjab) and the other is in Mumbai (possibly he is a an individual and not a registered dealer), third one is a registered dealer in Bangalore and the last one is an individual consumer just like you and me, and is not a registered dealer and stays in Mysore. The person wishes to bring the rest of the packed Roasted Coffee Powder back to Koraput, Odisha. The planter is a registered dealer under VAT in Odisha and has produced (manufactured) the coffee beans in his own gardens, and has applied for a CST Number but is yet to obtain the Number. We want to know: As to whether he can send the coffee beans to Bangalore for roasting without obtaining a CST Number beforehand. Or as to whether it is mandatory for him to get the CST registration first, before sending the Coffee beans to outside the state; As to how the person can generate the Way Bills from here and to send these to the transport carriers, for his sales to Chandigarh, Mumbai, Bangalore and Mysore. Tell me as to how he can do the necessary paper works and as to how he can pay the tax collected thus, As to how he can bring the rest of the roasted coffee powder back to Koraput that he can sell afterwards in the state and outside; He shall be sending samples of the Roasted coffee to Philippines and elsewhere, from Bangalore itself. May be in a subsequent times he might export, for which he has to send the roasted coffee powder to Mumbai; If the person wants to send the parchment coffee to Kushal Nagar in Karnataka to do the Curing Pre-Roasting) there, as to how he can send the processed coffee to the Roster at Bangalore. During Curing there is a loss of weight of about 20% too. Until the roasting is done, there will be no transfer of ownership, at any point of time, in between.
Is it possible to declare or create a cursor for update of table? If yes tell me how?
What are the built-in type does python provides?
What is knowledge representation and reasoning?