what is materialized view used datastage?
Answer / nams
It is just snapshot of runtime data as per business requirement
| Is This Answer Correct ? | 1 Yes | 3 No |
how can you generate sequence number using only the sequential file stage?
What is the difference between datastage and informatica?
Define oconv () and iconv () functions in datastage?
Main Function of the Staging area in DWH ?
How do y read Sequential file from job control?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
How will you move hashed file from one location to another location?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
Differentiate between operational datastage (ods) and data warehouse?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?