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
- 7808 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
What are the static cache and dynamic cache in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the conditions needed to improve the performance of informatica aggregator transformation?
What do you mean by channel change?
What is informatica etl tool?
How can we update a record in the target table without using update strategy?
What are active and passive transformations?
What are the differences between a connected lookup and unconnected lookup?
Under what condition selecting sorted input in aggregator may fail the session?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is joiner transformation in informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
