Interested to Buy Any Domain ? << Click Here >> for more details...
it is possible to load two tables data into one sequential
file?if possible how?plz share with me?
- 6 Answers
- 12864 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ramesh
sequential file has no storage memory limit. so that
possible.but hashed file is not possible.
| Is This Answer Correct ? | 0 Yes | 9 No |
Post New Answer View All Answers
What is a merge in datastage?
How do y read Sequential file from job control?
Where do the datastage jobs get stored?
Explain the importance of surrogate key in data warehousing?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What are the different type of jobs in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How do you remove duplicate values in datastage?
What is quality stage?
how to export or import the jobs in .ISX file
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How complex jobs are implemented in datstage to improve performance?
Define Data Stage?
How rejected rows are managed in datastage?
