I have source file which contains duplicate data,my
requirement is unique data should pass to one file and
duplicate data should pass another file how?
- 7 Answers
- 21579 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / krishna
As per my knowledge
initially soure is in sequential stage anc take aggrigator
stage and select the grouping option and select which column
you want to group then go to option command and select
column for calculation and select the which column you want
to do the operation .in column for calculation w have seen
many options and select missing count column name and give
the column name for output.and add transformer stage with in
the transformer stage add constraints .and give the two outputs
if column name=1 then 1 else 0
if column name>=2 then 1 else 0
it will work
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Triggers,VIEW,Procedures
Difference between data warehousing and olap?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How the ipc stage work?
Name the command line functions to import and export the DS jobs?
Describe the architecture of datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Give an idea of system variables.
Can you explain repository tables in datastage?
Define repository tables in datastage?
Explain connectivity between datastage with datasources?
How we can covert server job to a parallel job?
How can we improve the performance in datastage?
