hi this is kiran
i have one table i want divide the table with two different
table like even rows and odd rows
how can i do this one
tell me plzz
Answer Posted / farzana kalluri
Hi we can achive like this
Source--->Transformer---->filter--->2 targets
Transformer--->1.constraints--->mod(input,2)=0
2.constraint---->mod(input,2)=1
From this we can get the odd numbers in one target and
even numbers in one target...
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Difference between in process and inter process?
what are the errors,warnings in datastage
What is data partitioning?
What is job control?
What is datastage?
What are sequencers?
What are the types of containers and how to create them?
How to convert RGB Value to Hexadecimal values in datastage?
What is the roundrobin collector?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the project in datastage?
Explain usage analysis in datastage?
How one source columns or rows to be loaded in to two different tables?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the importance of the exception activity in datastage?