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
can you use flat file for lookup table?why?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
What is workflow manager?
How to fix the etl bugs..Tell me the process?
What if the source is a flat-file?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
Can we create a Integration service without a Repository service and vice versa?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the reusable transforamtions?
While migrating the data from one environment to another environment how would you manage the connections?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.