Hi
can anyone write query for the below input and output
Table 1
col 1
100
Null
200
300
Table 2
col1
Null
400
700
800
o/p
200
700
800
2)sql
col 1 contains
23x-5-45
26x-12-45
28x-10-50
o/p middlevalue should be greater than 10
- 0 Answers
- 1140 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
How can we use external procedural logic in informatica?
what are the types in error loging?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
what are the reports developed in sap bw project and what is the requirement for developing it?
what do u do when DB time takes more?in sap bi
What are the etl testing operations includes?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
What is Relational Integrity?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
how to connect to a flatfile through ftp in informatica
Teradata 
