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
- 5860 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 |
Design a mapping to get year of join for each employee.
What happens when a session fails and you click on recover?
Write the advantages of partitioning a session?
Explain what is informatica metadata and where is it stored?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How to get EVEN & ODD numbers separately?
if we have a delimiters at unwanted places in a flat file how can we over come those.
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
What is different between the data warehouse and data mart?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Teradata 
