what r the stages mostly used in realtime scenarios

Answer Posted / bietl

if you are working on server jobs then this are the stages
we can use commonly..

1.seq.file stage
2.transformer stage
3.hashfile stage
4.sort stage and agg.stage

if you are working on parallel jobs then this are the
stages we can use commonly..


1.Datset stage
2.transformer stage
3.lookupstage
4.Join stage
5.funnel and merge stage

mostly it's depends on the transformation logic and complex
of the logic..

I hope this will help..

Is This Answer Correct ?    26 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to implement complex jobs in data stage?

622


I have a few records just I want to store data in to targets cycling way how?

1907


What are orabulk and bcp stages?

657


How many types of sorting methods are available in datastage?

642


How do you run datastage job from the command line?

609






What are the components of datastage?

664


Differentiate between data file and descriptor file?

627


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2021


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

789


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1661


Differentiate between Join, Merge and Lookup stage?

656


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4576


Triggers,VIEW,Procedures

807


What is the difference between orabulk and bcp stages?

588


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1624