Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8925 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
sourc->transformer->filter->two targets
in the transformer stage we have append new column and
derviation area write mod(@outrownum,2) (where @outrownum in
sysvarible)
after that we put fileter or switch in that
write condition on append column 0 then even records
1 then go odd records
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nish
You could also go for a column generator and cycle the values 1,0.
then filter based on this column.
It will be much faster then employing a transformer stage having to generate @rownum and then do a mod calculation.
Trying to reduce the number of transformer stages is a key efficiency best practice.
| Is This Answer Correct ? | 0 Yes | 0 No |
options available in sequence job to run,validate?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
On which Dimension Table you implemented SCD Type in your Project
What is the roundrobin collector?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
Why we need datasets ratherthan sequential files?
How to find value from a column in a dataset?
What are the differences between datastage and informatica?
Teradata 
