Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rohit
I have below records.
EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-
101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
How many ways a relational source definition can be updated and what are they?
What is a surrogate key?
what is the complex transformation you used in informatica
What is the fact table?
How can we remove the duplicates from flat file source?
What is native users?
What is primary and backup node?
What is rank transformation?
How is union transformation utilized?
According to his methodology what all you need before you build a datawarehouse
What are the measure objects?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What will be the approach?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
