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
- 8909 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 |
where are the log files generally stored.Can you change the path of the file.what can the path be?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
Explain etl mapping sheets?
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 is the difference between project backlog and product backlog?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what are variable ports and list two situations when they can be used?
if u can't find what you are looking for in lookup table, how do you handle?
What are the steps involved in etl process?
what are the data modeling tools you have used?(polaris)
Explain different types of partitioning?
what is pmrep command?
Teradata 
