Answer Posted / saidarao
1.waht ever the data in the source is called intial load
(the data is already loaded in target is called before data)
2.the data which is generated after the data already loaded
is called after data
(the changes done in source are going 2 refresh the target
that is called incermental load)
per day-360 times
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How to read the length of word in unix?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
If you want to use the same piece of code in different jobs, how will you achieve it?
What are orabulk and bcp stages?
Differentiate between data file and descriptor file?
Describe routines in datastage? Enlist various types of routines.
Terminate Activity
Difference between sequential file and data set?
What are stage variables?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the primary usages of datastage tool?
project Steps,hits, Project level HArd things,Solved methods?
What are stage variables, derivations and constants?
How many types of sorting methods are available in datastage?