Interested to Buy Any Domain ? << Click Here >> for more details...
Hi This is Vijay,
How can your remove the duplicates in sequential File?
- 15 Answers
- 30943 Views
- HCL, Scope International, I also Faced
- E-Mail Answers
Answer Posted / rajesh
Go to Sequential File and then Select Filter Property
Set Filter = sort|uniq...........
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are orabulk and bcp stages?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What all are the different way to run a job?
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?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the roundrobin collector?
What is the difference between Datastage 7.5 and 7.0?
What are system variables and sequencers in datastage
What is staging variable?
Describe the architecture of datastage?
What all the types of jobs you developed?
Differentiate between operational datastage (ods) and data warehouse?
Difference between sequential file and data set?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
