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
- 7566 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 |
When do we analyze the tables? How do we do it?
flat filevalidation in informatica
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what are the different Reporting and ETL tools available in the market?
explain the methodology of Data Warehousing?(Polaries)
Explain do we need an etl tool?
what is dynamic insert?
what is the difference between OLTP database and data warehousing database?
what are the facilities provided by data warehouse to analytical users?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is factless fact schema?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
Teradata 
