Interested to Buy Any Domain ? << Click Here >> for more details...
what r the stages mostly used in realtime scenarios
- 4 Answers
- 25284 Views
- HCL, IBM, I also Faced
- E-Mail Answers
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 to sort two columns in single job in datastage.
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
options available in sequence job to run,validate?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
Can aggregator and transformer stages use to sort the data? How ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Explain usage analysis in datastage?
what is the exact difference between dataset and fileset in datastage?
how will u design file watch jobs?
what is repositery?
Explain Quality stage?
What is the difference between hashfile and sequential file?
Teradata 
