Interested to Buy Any Domain ? << Click Here >> for more details...
we have tables like
c1 a
c2 b
c3 c
c4 x
c5 y
and i need output like abcx in a single row and abcy in
a single row? how do u do this?
- 2 Answers
- 9967 Views
- Patni, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / krishnendu guha
I believe c1 c2 c3 are the columns
you can override the source qualifier with the following
query
select c1,c2,c3,c4 from table1
union all
select c1,c2,c3,c5 from table1
this should do..
| Is This Answer Correct ? | 10 Yes | 9 No |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
Define update strategy?
What are the data movement modes in informatica?
What is a sorter transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain target update override in informatica
explain one complex mapping with logic? sales project?
my source is junk data how will u remove that junk data by using unix please any one replay me
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the components of workflow manager?
What are the restrictions of union transformation?
How can you increase the performance in joiner transformation?
Enlist the advantages of informatica.
