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 |
Why we need datasets ratherthan sequential files?
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How we can convert rows to columns in datastage?
Difference between in process and inter process?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
Can aggregator and transformer stages use to sort the data? How ?
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT
what is normalization and denormalization
How do u convert the columns to rows in datastage?