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
- 8889 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
In warehouses how many schemas are there?
Write the program through which the records can be updated?
Can we create multiple integration service on single repository?
what is Active lock explain
What are the new features of informatica 9.x developer?
Can anyone tell me the new features in Informatica 9 Version?
What is the need of etl tools?
Explain incremental aggregation in informatica
What is meant by active and passive transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain how to import oracle sequence into informatica?
How can we use batches?
what is the complex transformation you used in informatica
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How do you load first and last records into target table?
