Can we use sequential file as source to hash file? Have you
do it ?if what error it will give?
Answer / srinivas
We can use sequential file as source for hash file it doesnt give any error .
If have any doubt try once.
Is This Answer Correct ? | 0 Yes | 0 No |
Is the value of staging variable stored temporarily or permanently?
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.
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
Name the different sorting methods in datastage.
What is job control?
What are the job parameters?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
What are the third party tools you used in your project?
What is ibm datastage?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
what are fact tables and dimension tables? give example assuming one table.
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers