how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 31060 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / ds
In Stage variable:
stage_variable3 <map> stage_variable1
if column=stage_variable1 than 0 else 1 <map>
stage_variable2
column <map> stage_variable3
Put stage_variable2 as constrain to target stage.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the difference between datastage and informatica?
How will you move hashed file from one location to another location?
What are the difference types of stages?
Does datastage support slowly changing dimensions ?
What is the differentiate between data file and descriptor file?
Define oconv () and iconv () functions in datastage?
In Datastage, how you can fix the truncated data error?
What are the types of containers?
Is the value of staging variable stored temporarily or permanently?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Triggers,VIEW,Procedures
How do you register plug-ins?
I have a few records just I want to store data in to targets cycling way how?
How to RD using transformer?
