Interested to Buy Any Domain ? << Click Here >> for more details...
I have a few records all are same structures data, I want to
store data in multiple targets how?
- 4 Answers
- 8701 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raman
Use the same job for loading by parameterizing the file
name the table name.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / geetha
Use transformer stage and modulus function. Lets say we have 4 target tables and set constraint to each target links as below.
Link1--> mod(@INROWNUM,4)=0
Link2--> mod(@INROWNUM,4)=1
Link3--> mod(@INROWNUM,4)=2
Link4--> mod(@INROWNUM,4)=3
we can also use filter stage and where clause to split the records
| Is This Answer Correct ? | 2 Yes | 0 No |
How the ipc stage work?
how can i abort the job if i get more than 100 errors in job log?
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
Differentiate between operational datastage (ods) and data warehouse?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
What is PX?
Can you explain players in datastage?
How can one find bugs in job sequence?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Teradata 
