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
- 8215 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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What do you understand by SOA of Informatica?
What is data transformation manager process?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Name the different lookup cache(s)?
Define Pmrep command?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the different types of transformation available in informatica.
If informatica has its scheduler why using third party scheduler?
What is resilience time?
Briefly define reusable transformation?
How do you update the records with or without using update strategy?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the different lookup cache(s)?
whats the logic to load the lower level of granularity of data to fact table.
