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
- 4 Answers
- 7500 Views
- I also Faced
- E-Mail Answers
Answer Posted / eswar
oracle stage--->surrogate key generator--->transformer
the t/f having 'mod' function
mod(empkey,2)=0 --->even rows
mod(empkey,2)<>0 --->odd rows
empkey is generated from surrogate key generator
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Have you have ever worked in unix environment and why it is useful in datastage?
how many rows sorted in sort stage by default in server jobs
What are the different types of lookups in datastage?
in oracle target stage when we use load option and when we use upsert option?
project Steps,hits, Project level HArd things,Solved methods?
Where do you see different stages in the designer?
What is the command line function to import and export the ds jobs?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the sortmerge collector?
What is a datastage job?
What is datastage engine?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
