my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?
Answer Posted / srikanth
hi
it is possible by using transform stage
select the function in that select the mathematical in that
select the mod function and run the job
you will get the answer
Thanks & regards
srikanth.k
9573056597
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Explain the situation where you have applied SCD in your project?
Can you explain link buffering?
What is the difference between orabulk and bcp stages?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
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 to reverse the string using SQL?
what is the use of materialized view?
How many areas for files does datastage have?
What are the steps needed to create a simple basic datastage job?
What is the difference between in process and inter process?
Differentiate between odbc and drs stage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is difference between symmetric multiprocessing and massive parallel processing?
Explain how a source file is populated?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this