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
What are the differences between datastage and informatica?
What are the processing stages?
What is datastage engine?
Why we use surrogate key?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Differentiate between datastage and datastage tx?
What is difference between server jobs & parallel jobs?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Define data aggregation?
what is the custome stage in datastage? how can we impliment that one? plz tell me
what is the use of surogate key in datastage
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Can you filter data in hashed file?