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 / 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
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Name the different sorting methods in datastage.
What are the different types of lookups in datastage?
What is the difference between datastage and datastage tx?
Can you explain how could anyone drop the index before loading the data in target in datastage?
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
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Explain ibm infosphere information server and highlight its main features?
What is the difference between hashfile and sequential file?
Define Routines and their types?
How to Remove Duplicate using SQL?
Which warehouse using in your datawarehouse
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is quality stage?
What is the flow of loading data into fact & dimensional tables?