Interested to Buy Any Domain ? << Click Here >> for more details...
I want skip first 5 rows to load in to target? what will be
the logic at session level ??
- 1 Answers
- 6996 Views
- IBM, I also Faced
- E-Mail Answers
Answer / nitin
The one way to skip records for relational sources would be
adding a SQL Query in session properties.
SELECT * FROM EMPLOYEE
MINUS
SELECT * FROM EMPLOYEE WHERE ROWNUM <= 5
This query would skip the first 5 records.
| Is This Answer Correct ? | 7 Yes | 0 No |
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Under what condition selecting sorted input in aggregator may fail the session?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
How can you join two tables without any common column present in them?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
What are the mapings that we use for slowly changing dimension table?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
What is meant by lookup transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain the different kinds of facts.
Teradata 
