Interested to Buy Any Domain ? << Click Here >> for more details...
I am hvaing SOURCE as first line: 1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
null,null,null,4000 ............................Now i want
the OUTPUT as 1000,2000,3000,4000 For more clarification i
want to elimate nulls and want in a single line. Please
help me out
- 2 Answers
- 6699 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
select no,max(col1),max(col2),max(col3),max(col4) from
tablename group by no;
| Is This Answer Correct ? | 7 Yes | 0 No |
Two different admin users created for repository are ______ and_______
how to create user defined function (udf) in informatica
Router T/R is active but some people are saying it is also passive which is exactly right?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
What is workflow? What are the components of workflow manager?
what is the difference between mapplet & stored procedure?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Enlist the differences between database and data warehouse.
How to update a particular record in target with out running whole workflow?
In target table how to display the system time
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
Teradata 
