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
- 6579 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / durgaprasad
select no,max(col1),max(col2),max(col3),max(col4) from
tablename group by no;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Briefly define a session task?
How can we use mapping variables in informatica? Where do we use them?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Enlist some properties of sessions.
what are the Methods For Creating Reusable Transformations?
what are the deliverables?in your project?
What is workflow? What are the components of the workflow manager?
Please let me know how to make Data masking in informatica..
Define joiner transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the function of look up transformation?
What are the various types of transformation?
How to partition the Session?
How do you load first and last records into target table?
How to join three sources using joiner? Explain though mapping flow.
