Interested to Buy Any Domain ? << Click Here >> for more details...
What are the prerequisites for join stage
- 2 Answers
- 9510 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
1.Inputs as left right and intermediate links(files).
2.can do left outer,right outer,inner join and full outer join
3.N inputs for left,right and inner but 2 inputs for full outer.
4.Inputs should be sorted and partitioned for better
performance.
5.Removing duplicates is optional as join operation is
highly optimized which sequential and less i/o and less page
faults.
6.Memory requirements are comparatively less than Lookup stage.
7.In join key columns names should be same in primary and
secondary datasets.
| Is This Answer Correct ? | 0 Yes | 0 No |
Have you have ever worked in unix environment and why it is useful in datastage?
I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
how to transfer file from one system to another system in unix? which cmd to be use?
what is flow of project?
what is the unix script to run the job? Please mention commands which we use often?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are orabulk and bcp stages?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
What are the types of containers in datastage?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
What is the difference between operational data stage (ods) and data warehouse?
Teradata 
