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
explain about citrix scheduling tool in datastage
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Where the datastage stored his repository?
what is the use of skid in reporting?
What are the types of hashed files in data stage
Why do you need stage variables?
Differentiate between datastage and informatica?
What is the project in datastage?
What is the difference between server job and parallel jobs?
Why do we use exception activity in Datastage?
What all are the different way to run a job?
What are the main differences you have observed between 7.x and 8.x version of 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
Define Job control?