Interested to Buy Any Domain ? << Click Here >> for more details...
we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record
- 3 Answers
- 8918 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / zslstar
we can use the sql below to indicate the rownum.
then router the data according to the rownum from upstream.
select t.*,rownum rn from test t
where mod(floor(t.rn/10),2) =0 --get the rows whose rownum
between 1~9,20~29,etc.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / swetha
we can use sequence generator with cycle for that
| Is This Answer Correct ? | 4 Yes | 3 No |
Use seq. Generator to create sequence or you can use expression transformation to create sequence, then in router transformation create 10 group and give conditions like seq >1 and seq <11, seq>11 and seq <20 etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is data modeling?
Explain about the data integration suite features?
Can u access a repository created in previous version of Informatica?
what are variable ports and list two situations when they can be used?
what is granularity in Data ware House?
tell me few points when u become TL
When do we go for the tools in the market?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
what do u do when DB time takes more?in sap bi
Define Dynamic push down optmization?
Explain what is etl process? How many steps etl contains explain with example?
What are the steps involved in etl process?
Teradata 
