Interested to Buy Any Domain ? << Click Here >> for more details...
how to closeing records after 10,000 records come?
- 3 Answers
- 6501 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
-->If the Source is File:
"Read First Rows"=10000 --> Only read the first specified number of rows from each file.
"Filter"= sed -n '1,10000 P' or head -10000: we can use UNIX commands to filter the data.
-->If source is DB:
Oracle: where rownum<=10000
DB2: sample 10000 row only
Teradata: fetch first 10000 rows only
-->In Transformer:
We can use @INROWNUM<=10000 system variable
We can use Stage variables and count the values and in the contraints part use Stage_Var<=10000
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / amulya kumar panda
In transformer stage has system variable and select
@INROWNUM <10000
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
while before running the job it ask stop incoming rows and
warnings thete we to mention number of records
| Is This Answer Correct ? | 0 Yes | 3 No |
how to sort two columns in single job in datastage.
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
Please tell me What is difference between 8.0 and 8.1
What are the different type of jobs in datastage?
Differentiate between hash file and sequential file?
can we half project in parallel jobs and half project in server jobs?
How many jobs in ur project? Explain any complex job u have done in ur project?
What is data partitioning?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Teradata 
