Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 10 Answers
- 17470 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / abd
We can use stage variable in Tran Stage
IF @INROWNUM MOD 4 = 0 then T4
Else If @INROWNUM MOD 4 = 1 then T1
Else If @INROWNUM MOD 4 = 2 then T2
Else If @INROWNUM MOD 4 = 3 then T3
Try this
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Name the command line functions to import and export the DS jobs?
How to reverse the string using unix?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
what are the errors,warnings in datastage
How do you schedule or monitoring the job?
what is the use of surogate key in datastage
What is the difference between an operational datastage and a data warehouse?
What are some different alternative commands associated with "dsjob"?
how to sort two columns in single job in datastage.
How one source columns or rows to be loaded in to two different tables?
What is a quality stage in datastage tool?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How do you import and export data into datastage?
