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?
No Answer is Posted For this Question
Be the First to Post Answer
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
source file is having 5 records while moving into target it want to be 10 records
Can you explain repository tables in datastage?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
What are system variables and sequencers in datastage
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
If you want to use a same piece of code in different jobs, how will you achieve this?
what is initial load and incremental load
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
Why fact table is in normal form?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?