Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 2599 Views
- TCS, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How union transformation is active ?
What is a grid in Informatica?
Difference between Target-based loading and constraint-based loading?
What is the scenario which compels informatica server to reject files?
what is the difference between stop and abort?
What is option by which we can run all the sessions in a batch simultaneously?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what are the challenge face in u r project?explain me
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
Teradata 
