What is difference between join, merge and lookup stage?
No Answer is Posted For this Question
Be the First to Post Answer
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
What is Horizontal transformation, vertical transformation,diagonal transformation?
What is RCP
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 are the types of nodes
What are the different types of lookups in datastage?
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
What all are the different way to run a job?
how many write modes are there in ds
Where do the datastage jobs get stored?
i want job aborted after some records are loaded into output by using only sequential stage and dataset