write s sql query following table some duplicate present i
want unique one column duplicate another column display?
name id
a 1
a 1
b 2
b 2
c 3
i want the required output like
unique duplicate
name id name id
a 1 a 1
b 2 b 2
c 3
- 4 Answers
- 8176 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / chandan023
1.Sort the data
2.Expression transformation
a)create a variable1(integer) and var2(string)
b) var2 = concatenate all fields
b) set the value of the variable to 1 if (concat all fields are = var2)
c) create a o/p port = var2
-- output of the expression t/f will be like
NAME ID NEW_COL
a 1 0
a 1 1
b 1 0
b 1 1
c 1 0
3. Use a router transformation and route the data based on the new thirt column.
Happy ETLing :)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the scenario which compels informatica server to reject files?
How to load the data from people soft hrm to people soft erm using informatica?
What is joiner transformation in informatica?
What are the different options available for update strategy?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is xml source qualifier transformation in informatica?
How many ways a relational source definition can be updated and what are they?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is aggregate cache in aggregator transformation?
what is index?how it can work in informatica
Design time, run time. If you don't create parameter what will happen
what are the deliverables?in your project?
What are the components of the workflow manager?
Explain in detail about scd type 1 through mapping.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
