Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subbuchamala
-->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 |
Post New Answer View All Answers
Define orabulk and bcp stages?
How do y read Sequential file from job control?
What are the types of hashed files in data stage
Is the value of staging variable stored temporarily or permanently?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you define merge?
Can you explain tagbatch restructure operator?
Differentiate between operational datastage (ods) and data warehouse?
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
What is "fatal error/rdbms code 3996" error?
What are the functionalities of link partitioner?
What is a ds designer?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
