How much data u can get every day?
2)which data ur project contains?
3) what is the source in ur project?what is the biggest
table & size in ur schema or in ur project?
Answers were Sorted based on User's Feedback
Answer / kiran
1.How much data u can get every day?
Ana: Exactly no one tell how much data will get and its
depend upon company 2 company and client 2 client.and first
u analyze.Are u in developer or production side.data will
get only in production side not in development side.
Approximately u can tell as like 5 lakhs record per day
2)which data ur project contains?
Ans:Flat files.
3)what is the source in ur project?what is the biggest
table & size in ur schema or in ur project?
Ans:first u will get all data in sourse file as test then
will popuylate 2 oracle then cleansing and finally populated
2 dataware house
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / kiran
1.How much data u can get every day?
Ana: Exactly no one tell how much data will get and its
depend upon company 2 company and client 2 client.and first
u analyze.Are u in developer or production side.data will
get only in production side not in development side.
Approximately u can tell as like 5 lakhs record per day
| Is This Answer Correct ? | 3 Yes | 1 No |
Is possible to create skid in dim,fact tables?
How to initialize environment variables?
How do you design PX Routines ?
What are the repository tables in datastage?
Highlight the main features of datastage?
What modeling tool do you use?
How did you reconcile source with target?
What are the steps needed to create a simple basic datastage job?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
How did you reconcile source with target?
What are the different common services in datastage?
Define orabulk and bcp stages?