Interested to Buy Any Domain ? << Click Here >> for more details...
Can anybody tell me in detail any complex datastage job? I
have worked only in direct load and full refresh jobs.But in
all interviews this question arises
- 1 Answers
- 4224 Views
- TCS, I also Faced
- E-Mail Answers
Answer / lakshmi
Working up with fact jobs is a complex one as to gather the source from multiple dimensions in to one dataset, while gathering it may endup with joining many lookups and db connectors.
| Is This Answer Correct ? | 0 Yes | 0 No |
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is audit table?
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
how to export or import the jobs in .ISX file
What are transforms and what is the differenece between routines and transforms?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Define repository tables in datastage?
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?
How do you remove duplicate values in datastage?
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
Teradata 
