Interested to Buy Any Domain ? << Click Here >> for more details...
How to load time dimension?
- 1 Answers
- 15749 Views
- Ford, I also Faced
- E-Mail Answers
Answer / shashiall
Run the procedure to load the ttime dimension.Its not
loaded frequently,but once or twice a year.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the query to find nth highest salary? What is the use of cursors?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to generate sequence numbers?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
What is workflow? What are the components of the workflow manager?
Which version configuration tool used in ur project?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
what is the look up transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is workflow? What are the components of workflow manager?
Teradata 
