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 |
Lookup constraints
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Nls stands for what in datastage?
How to delete the data in dataset?types of deleting the data in dataset?
What is data partitioning?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
How to remove duplicates in transformer stage? in parallel mode
what is the best stage in datastage parller jobs to use full out join and why
Describe the architecture of datastage?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
How to move data set from one server to other?what are the steps to follow to do this?
What are the benefits of datastage?