i have one table with one column in this column i have three
rows like 1,1,2 then that rows populate to target as first
tow rows as one row and remaing row as one row how it posible?
COLUMN_NAME
SHIVA
RAMU
MADHU
THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND
MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
Answer Posted / prasad
Question is not clear.
U want 1,1 records goes to one target and duplicate records goes to another target, is it right? can u plz conform this and just let me know?
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
CHANGE CAPTURE
What is the difference between orabulk and bcp stages?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Whats difference betweeen operational data stage (ods) and data warehouse?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is a quality stage in datastage tool?
How can you write parallel routines in datastage PX?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are the types of jobs we have in datastage?
Explain connectivity between datastage with datasources?
how to delete one row in target dataset
Different ways a project can be moved to production ?...example ….export-import and Version control.
How to RD using transformer?
How to reverse the string using SQL?