write sql query vertical to horiozontal following table
id name
1 100
2 dinesh
3 india
1 101
2 suresh
3 india
1 103
2 prakesh
3 usa
i want output like
id name country
100 dinesh india
101 suresh india
103 prakesh usa
No Answer is Posted For this Question
Be the First to Post Answer
How to differentiate between the active and passive transformations?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Which is the t/r that builts only single cache memory?
if soource is having 10 records how will u insert 20 records to target
scd methodology?
Which files are created during the session rums by informatics server?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
How are the sources and targets definitions imported in informatica designer?
whether Sequence generater T/r uses Caches? then what type of Cache it is
What is the cumulative sum and moving sum?