what r the stages mostly used in realtime scenarios
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / balaji
these are mostly used in real time scenario:
database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage.
debugging stage are:
1.head stage
2.tail stage
3.peek stage
Is This Answer Correct ? | 12 Yes | 5 No |
these are mostly used in real time scenario:
database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage
12.Change Capture
13.Filter
debugging stage are:
1.head stage
2.tail stage
3.peek stage
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / kishore reddy
database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage.
Is This Answer Correct ? | 2 Yes | 0 No |
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
What are the functionalities of link partitioner?
What are operators in datastage?
What is mapping?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Difference in the implementation of lookup and join stages,in joining two tables?
What are stage variables and constants?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
What is diff between Junk dimensions and conform dimension?
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Can you define merge?
What are some different alternative commands associated with "dsjob"?