Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8769 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 difference between mapping parameter and mapping variable?
What are the components of Informatica? And what is the purpose of each?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Implementation methodology
Is there any target staging area in informatica not staging area
In how many ways we can create ports?
What is DR strategy for Informatica project?
What are data-driven sessions?
Define sessions in informatica etl?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Differentiate between Load Manager and DTM?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Differences between version 7.x and 8.x.
What is the need of an ETL tool?
What are the informatica performance improvement tips
